Dealing with FALSE and O responses to IF formulas
 

Maybe, you can help me with a couple of problems that I am having with an
Excel worksheet.

In one case, I have an IF argument, which includes a CONCATENATE argument.
It is all tied to the referenced field in the IF argument being greater than
1. If it is blank, I have written the formula to return a "" but instead it
returns a FALSE.

In the other case, I am trying to write an IF argument that state that, if a
text field is blank or "", I want it to return a "". What I get is a 0.

Any thoughts?

Why not share your formulas and values with us?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Tom Atlanta" <Tom wrote in message
...
Maybe, you can help me with a couple of problems that I am having with an
Excel worksheet.

In one case, I have an IF argument, which includes a CONCATENATE argument.
It is all tied to the referenced field in the IF argument being greater
than
1. If it is blank, I have written the formula to return a "" but instead
it
returns a FALSE.

In the other case, I am trying to write an IF argument that state that, if
a
text field is blank or "", I want it to return a "". What I get is a 0.

Any thoughts?

Hi
do you mean
=IF('sheet1'!A1="","",'sheet1'!A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"Tom Atlanta" <Tom schrieb im
Newsbeitrag ...
Maybe, you can help me with a couple of problems that I am having
with an
Excel worksheet.

In one case, I have an IF argument, which includes a CONCATENATE
argument.
It is all tied to the referenced field in the IF argument being
greater than
1. If it is blank, I have written the formula to return a "" but
instead it
returns a FALSE.

In the other case, I am trying to write an IF argument that state
that, if a
text field is blank or "", I want it to return a "". What I get is a
0.

Any thoughts?