Get rid of the zeros?!


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
 
Ad

Advertisements

D

Dave Peterson

=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.
 
N

Nick Hodge

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)
 
Ad

Advertisements

G

Guest

Hi,

You may use conditional formatting on the Format toolbar.

Regards,
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Rid of Zeros 17
Get rid of Duplicates 1
getting rid of blanks 0
Get rid of #N/A 1
Get Rid of N/A 6
Get rid of #value! 0
Getting rid of empty cells 2
Getting rid of !ZeroDivide error 4

Top