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
B2 is blank instead of showing a zero?
Thanks for the help
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sean Timmons
=if(A1=0,"",A1)
or to cover null,
=if(OR(A1=0,A1=""),"",A1)
or to cover null,
=if(OR(A1=0,A1=""),"",A1)
J
JoeU2004
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?
=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.
J
Jacob Skaria
Could be even
=IF(A1,A1,"")
If this post helps click Yes
=IF(A1,A1,"")
If this post helps click Yes