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

Maggie · May 28, 2008

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

Teethless mama · May 28, 2008

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

muddan madhu · May 28, 2008

can it be ?

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

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

- Show quoted text -