| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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% |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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% |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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% |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting the cells of a formula causes the formula to not work | Excel Worksheet Functions | |||
| WHY doesn't formula work??? | Excel Discussion (Misc queries) | |||
| Formula will not work | Excel Discussion (Misc queries) | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| My formula won't work | Excel Worksheet Functions | |||
Linear Mode
