| 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% correctly, but it won't calculate the 75% or 100% at all, it just stays at 50% |
| 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 | |||
| Formula will not work | Excel Discussion (Misc queries) | |||
| FORMULA DOESN'T WORK | Excel Discussion (Misc queries) | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| formula won't work | Excel Worksheet Functions | |||
Threaded Mode
