One way...

Start from the upper boundary and work down:

=IF($B$57000000,10,IF($B$56000000,9,IF($B$55000 000,7,IF($B$54000000,5,IF($B$5<=4000000,0,"")))))

--
Biff
Microsoft Excel MVP


"steve12173" wrote in message
...
I have an IF Statement to give me a number based on sum of another cell.
It
looks like this: =IF($B$5<4000000, "0",
IF($B$54000000,"5",IF($B$55000000,"7",IF($B$560 00000,"9",IF($B$57000000,"10")))))

If my number is less than 4000000 it gives me the "0" and if it is greater
than 4000000 it gives me "5" but, if the number is greater than 5000000 it
still gives me "5" rather than the correct number. Anyone see what I am
doing wrong?