S
Scoober
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
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