= IF blank

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

If I have B2 referring to A1 and A1 has no data, how do I write this so that
B2 is blank instead of showing a zero?

Thanks for the help
 
Jim said:
If I have B2 referring to A1 and A1 has no data, how do I write
this so that B2 is blank instead of showing a zero?
Click to expand...

=if(A1="", "", A1)

Do not use IF(ISBLANK(A1),"",A1). That works only when A1 is truly empty,
i.e. it has no formula and no constant. But as you can with the result in
B2, your perception of a cell with "no data" might be misled by a formula
that results in the null string.

Of course, if you truly want to distinguish between the null string and
truly empty -- very rare -- ISBLANK() is indeed the function to use.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date and If problem 6
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
b;ank cells in calculations 2
Count 4
Want it to be blank if date has not been added 4
Referencing a cell even if its contents are moved moved/replaced 6
Text format and missing value. 6
So simple, but I can't get it to work 3

Back
Top