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