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