Linking cells...easy one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
You could use an IF statement.

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

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

HTH,
Elkar
 
Back
Top