If a number is between 1 & 4 then do X else do XY

[Maggie]

I want to find out how to do an If formula which gives a result if the
condition is between two numbers?

 

[Teethless mama]

=IF(AND(A1>=1,A1<=4),"X","XY")

 

[muddan madhu]

can it be ?

=IF((A1>0)*(A1<5),"X","XY")

=IF(AND(A1>=1,A1<=4),"X","XY")





- Show quoted text -