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
 

Try this:

=LOOKUP(F5,{0,3000,5000,7000},{0.25,0.5,0.75,1})


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

Formula won't work
 

Hi George,
The second IF statement traps all other conditions, since 5000 and 7000 is
=3000.
You need to reverse the order of the last 3 statements, starting with the
largest, going down.
Regards - Dave.

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

Formula won't work
 

See answers to your earlier, similar post.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"George" wrote in message
...
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%