Hi,
You need to use
=IF(AND($B$54000000,$B$5<5000000),"5",IF(AND($B$5 5000000,$B$5<6000000),"7",IF(AND($B$56000000,$B$ 5<7000000),"9",IF($B$57000000,"10",""))))

I added a condition to leave it blank if it is less than 4000000, you can
take it just delete ,"" after 10


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