That is because 500 and 700 are = 3000, so it doesn't look any further
Change the order of testing the threshold values

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"George" wrote in message
...
Hello, can someone please help me with the following formula;
=IF(F5<=2999.99,"25%",IF(F5=3000,"50%",IF(F5=500 0,"75%",IF(F5=7000,"100%"))))
For some reason it calculates the 25% and 50%, but it will not calculate
the
75% or 100%, it just stays at 50%