Update a cell contents otherwise show blank

  • Thread starter Thread starter ndavies
  • Start date Start date
N

ndavies

I'm trying to update a cell on another worksheet from data inputted int
sheet1.

Problem is, if the cell that I need to update from is empty, the secon
sheet shows a "0". I want it show nothing if the cell on first sheet i
empty.

The nearest I can get to is this entry that I insert into the cell t
be updated. Works to the point that if the source cell is empty, bu
fails if the source cell contains data.

=IF('sheet1'!A11>0,='sheet1'!A11,"")

Can anyone help me with this please. Go easy, my excel experience i
limited!

Thanks in advance.
N
 
I'm trying to update a cell on another worksheet from data inputted into
sheet1.

Problem is, if the cell that I need to update from is empty, the second
sheet shows a "0". I want it show nothing if the cell on first sheet is
empty.

The nearest I can get to is this entry that I insert into the cell to
be updated. Works to the point that if the source cell is empty, but
fails if the source cell contains data.

=IF('sheet1'!A11>0,='sheet1'!A11,"")

Can anyone help me with this please. Go easy, my excel experience is
limited!

Thanks in advance.
ND
Click to expand...

You have too many '=' signs:

=IF(Sheet1!A11>0,Sheet1!A11,"")


--ron
 
Thanks to everyone for help with this.

Tried Frank's suggestion as it was the only one posted when I last looked,
it worked as required.

Regards
Nigel
 
Back
Top