Get rid of the zeros?!

  • Thread starter Thread starter mevetts
  • Start date Start date
M

mevetts

Hi,

I have got two worksheets and have set-up some simple formulas tha
just copy whatever is typed into a cell on the first sheet into th
same cell onthe second sheet. e.g. =Registers!B58

However, if nothing is typed into the cell then a pesky 0 appears o
the second sheet. Is there anyway of preventing this?

Many thanks,

Mark
 
=if(Registers!B58="","",Registers!B58)


Hi,

I have got two worksheets and have set-up some simple formulas that
just copy whatever is typed into a cell on the first sheet into the
same cell onthe second sheet. e.g. =Registers!B58

However, if nothing is typed into the cell then a pesky 0 appears on
the second sheet. Is there anyway of preventing this?

Many thanks,

Mark.
 
Mark

You need to wrap it in an IF function

=IF(Registers!B58="","",Registers!B58)

or Tools>Options...>View and uncheck 'zero values'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Back
Top