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

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

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

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

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