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")
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top
IF(A1>0,IF(A1<10,"Yes","No"),"No")
IF(AND(A1>10,A1<10),"Yes","No")