That worked perfectly, thanks. I never thought of putting the info in
backwards.

"Jacob Skaria" wrote:

4000000 returns true for any number above that and hence returns 5 always./
Try this...

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

--
If this post helps click Yes
---------------
Jacob Skaria


"steve12173" wrote:

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?