Logic for excel

[dannybek]

Hi guys I am working on a spreadsheet and I don't know if I got this right
Here is the thing I want excel to do.
If the amount is $249 or less then the level will be I
If the amount is more than or equal to $250 or less than or equal to $499 then level is II
If the amount is more than or equal to $500 or less than or equal to $999 then level is III
If the amount is more than or equal to $1000 more then level is IV

I put this as the equation and got FALSE
=IF(I7<249,"I",IF(250<=I7<=499,"II",IF(500<=I7<=999,"III", IF(1000<=I7<=100000,"IV"))))

Can someone help me correct this equation? Thankyou!

 

[minendo]

Why not use a lookup function?

 

[dannybek]

I never played with excel until this Monday. I only found out about these logic functions this morning and have been studying on the internet on how to use them. So far I am pretty good with the simple mathematics. This is my most ambitious equation yet. I am sorry i don't know what a lookup function is. How does that work?

 

[Evadman]

You need to understand that an if statement in excel ends at true.

=IF(A1>=1000,"IV",IF(A1>=500,"III",IF(A1>=250,"II","I")))

<edit>
change A1 to whatever cell you are checking BTW

 

[NeoV]

=if(I7<=249,"I",if(I7>=250,if(I7<=499,"II",if(I7<=999,"III","IV"))))

 

[dannybek]

Wow Thank you. It looks so simple. So Pure. So cool.