That is because once the IF statement is happy with $B$54000000, then rest
of the IF is never even checked.
--
Gary''s Student - gsnu200857


"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?