Dealing with FALSE and O responses to IF formulas

[Tom Atlanta]

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?

 

[Niek Otten]

Why not share your formulas and values with us?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Frank Kabel]

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