On Feb 13, 4:14*pm, George wrote:
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%

Try this one
=IF(F5<3000,"25%",IF(F5<5000,"50%",IF(F5<7000000," 75%","100%")))
In your formula. if a number is bigger than 3000, then obviously it
will be greater than 5000 and 7000 therefore it will never pass this
step.
HTH