=IF(A6="","",A6)

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


"Scoober" wrote:

Hi,

I am trying to find the formula that allows me to copy a name from one cell
to another, but if the original cell is empty then the corresponding cell is
also empty.

A6 B9
John Smith John Smith formula: =A6

But when A6 is empty I get a zero in B9.

I have tried this =IF(A6="",""),A6 but it comes up with a ##### error
message.

Can anyone help

Cheers Scott