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

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

or to cover null,

=if(OR(A1=0,A1=""),"",A1)

"Jim" wrote:

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" wrote:
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?

=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.

Could be even
=IF(A1,A1,"")

If this post helps click Yes
---------------
Jacob Skaria


"Jim" wrote:

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