| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula does not calculate blank answer
Hello
What's wrong with this formula =IF((AO409+AP409)<0.5,(AO409+AP409),0.5),'' ", IF(AO409+AP409)<0.5,(AO409+AP409),0.5)) I tested the formula with the first part IF((AO409+AP409)<0.5,(AO409+AP409),0.5) and that works but when I added the second part it does not work . THe columns have numbers but sometimes there is text in the columns, so when there is text I want the cell to be blank thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Formula and blank answer | Excel Discussion (Misc queries) | |||
| Data not entered yet - formula calculate blank | Excel Discussion (Misc queries) | |||
| Need a formula to calculate greater than & show answer as a % | Excel Worksheet Functions | |||
| blank cells in a formula gives me an answer not acceptable to prin | New Users to Excel | |||
| How do I calculate a formula with a not-to-exceed answer? | Excel Discussion (Misc queries) | |||
Threaded Mode
