Question about IF

J

juanpablo

Hi,

If I have a number X and I want to apply and IF the number X >1000 and <
2000,

How do I implement that in the formula
Because IF(X>1000<2000;"") wont work,

help please
 
J

jtoupence

use this:
=IF(A1<1001,"Nope",(IF(A1<2000,"Yippee","Nope")))

There mught be an easier way but this will work
 
R

Ron Rosenfeld

Hi,

If I have a number X and I want to apply and IF the number X >1000 and <
2000,

How do I implement that in the formula
Because IF(X>1000<2000;"") wont work,

help please
Click to expand...

=IF(AND(X>1000,X<2000);...)
--ron
 
Top