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
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
Facebook
Twitter