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

There mught be an easier way but this will work

"juanpablo" wrote:

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(X1000<2000;"") wont work,

help please