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?