Formula Won't Work
 

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%

Formula Won't Work
 

George,

Look carefully at your formula and you'll see why it doesn't work

=IF(F5<=2999.99,"25%",IF(F5=3000,"50%",IF(F5=500 0,"75%",IF(F5=7000,"100%"))))

If B5 is =100000 then it's greater than 3000 so you'll see 50% because it
stops evaluating at the first TRUE condition. Reverse the order of evaluation
from highest to lowest and your there.


=IF(F5<=2999.99,"25%",IF(F5=7000,"100%",IF(F5=50 00,"75%",IF(F5=3000,"50%"))))

Mike

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