Using IF function to return value if equal to or below figure

[mrsdeapsleap]

Hi all,

Trying to get an IF formula working for a banded pricing policy. I have a total figure, and depending on whether it is below or equal to another figure, I want the formula to return Band 1, Band 2, Band 3 or Band 4 in an adjacent cell. IE. if my total figure is equal to or below £15,999.99 I want it to show Band 1 next to the total cell, if it is above or equal to £16,000 and below £17499.99, then return Band 2, if above or equal to £17,500 and below £19,499.99, then return Band 3, and if over £19,500.00 return Band 4.

Any help would be much appreciated!

Emma.

[etaf]

you could do a couple of ways
1) with an IF and imbed the values
2) with a table and lookup the values

=IF( Cell > 19500 , "Band 4" , IF( Cell >= 17500 , "Band 3" , IF( Cell > = 16000 , "Band 2", "Band 1" )))

You seem to have > or equal to on some values but not all
but you can adjust as required