Help with logical on 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!


--
dupe
AnandTech Moderator Evadman

 

[MagnusTheBrewer]

http://forums.anandtech.com/ca...tid=33&flcache=3875810
There ya go!

 

[dannybek]

good call.