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% correctly, but it won't
calculate the 75% or 100% at all, it just stays at 50%
 
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% correctly, but it won't
calculate the 75% or 100% at all, it just stays at 50%
Click to expand...

See the other same question
 
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% correctly, but it won't
calculate the 75% or 100% at all, it just stays at 50%
Click to expand...

=IF(F5<=2999.99,"25%",IF(F5>=3000,"50%",

If F5>=3000, your second IF conditional evaluates to TRUE and the 50% statement
gets executed. Your function will never go past that.

You need to ensure that your conditionals are mutually exclusive, otherwise the
first one will get executed.

Write your IF statements in descending order and you will avoid that problem:

=if(f5>=7000,100%,if(f5>=5000,75%,if(f5>=3000,50%,25%)))

Also, if you want to use the result of this formula in a math function, don't
use the quotation marks, as they will return the result as TEXT (which will not
be recognized as a number by some Functions).
--ron
 
Because in an IF statement, once the the test is TRUE, the Else is not
evaluated. Reorder your test with that in mind.
 
Check in descending order:

=IF(F5>=7000,100%,IF(F5>=5000,75%,IF(F5>=3000,50%,25%)))

And I would think that you would want a real number returned--not text.

Make sure you format the cell as a percentage, too.
 
Hi George,

It's because once you have any number in F5 greater than 3000, the second If
statement is fulfilled and the formula never gets to the later stages.

You could readjust your less than and greater than arguments but here is
another way to do it.

=LOOKUP(F5,{0,3000,5000,7000},{"25%","50%","75%","100%"})

HTH
Martin
 
Back
Top