formula does not calculate blank answer

[Wanna Learn]

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

 

[Bob Umlas, Excel MVP]

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))

 

[Peo Sjoblom]

The second part is obsolete since it is the same as the first


=MIN(AO409+AP409,0.5)

--


Regards,


Peo Sjoblom

 

[John C]

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.

 

[Dan]

Try this also,
=If(iserror(a2+b2),"",if((a2+b2)<.5,(a2+b2),.5))