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