On Fri, 13 Feb 2009 05:12:04 -0800, George
wrote:

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

=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