Test if a cell is between 2 numbers

IF(A1>0,IF(A1<10,"Yes","No"),"No")
IF(AND(A1>10,A1<10),"Yes","No")


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top