Formula Won't Work

  • Thread starter Thread starter George
  • Start date Start date
G

George

Hello, can someone please help me with the following formula
=IF(F5<=2999.99,"25%",IF(F5>=3000,"50%",IF(F5>=5000,"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%
 
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>=5000,"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>=5000,"75%",IF(F5>=3000,"50%"))))

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Won't Work 5
Formula won't work 3
Formual Won't Work 9
need to subtract .50 from a cell if it is over 6.00 4
IF Statement troubles 3
How do I express the following calculation. 3
In Excel if is more than 25% from start date then make cell red 3
Formula??? 8

Back
Top