Linking cells...easy one

S

SLKoelker

Hi FSt1: I was looking for a way to link cells on the same sheet and your
response to this post helped, however is there a way to make it so that when
there is nothing entered in cell A1, D5 is blank, mine show up as 0??
 
E

Elkar

You could use an IF statement.

=IF(A1="","",A1)

So, if A1 is blank, then return blank, else return value of A1.

HTH,
Elkar
 
Top