Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting the cells of a formula causes the formula to not work | Excel Worksheet Functions | |||
formula using vba does not work .. | Excel Discussion (Misc queries) | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
formula doesn't work | Excel Discussion (Misc queries) | |||
How does this formula work | Excel Worksheet Functions |