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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula does not calculate blank answer
The syntax is wrong. Syntax is =IF(condition,true value,false value)
Your condition is (AO409+AP409)<0.5 your true value is (AO409+AP409) your false value is 0.5. So Excel doesn't know what you're trying to do with the rest. You have another comma then " ", etc. and the syntax is invalid. The whole first part can be reduced to =MIN(AO409+AP409,0.5) -- no IF needed. If you just want blank if there's text: =IF(COUNT(AO409:AP409)<2,"",MIN(AO409+AP409,.5)) "Wanna Learn" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula does not calculate blank answer
The second part is obsolete since it is the same as the first
=MIN(AO409+AP409,0.5) -- Regards, Peo Sjoblom "Wanna Learn" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula does not calculate blank answer
Honestly, I cannot tell what is right with the formula. You seem to be
reqeusting to do the same IF statement twice. Please try to explain what you are trying to do. It sounds like you are looking for a nested IF statement, but from the first information I see, that may not be necessary. -- John C "Wanna Learn" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula does not calculate blank answer
Try this also,
=If(iserror(a2+b2),"",if((a2+b2)<.5,(a2+b2),.5)) "Wanna Learn" wrote: 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 |
Reply |
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) |