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