Zeros when copying formular

K

Keith Camacho

I copied a formular down 10 cells for future input. The cells are all
showing 0.00, until I enter a value on the other side where the calculation
will originate from. Can I hide those zeros and still have my formular
intact.
Thanks.

/keith
 
G

Gord Dibben

Keith

You can turn off zeros in Tools>Options>View.

You could also use an IF formula to return a blank cell if a zero is present.

=IF(A1 + B1=0,"",A1 + B1)


Gord Dibben Excel MVP
 

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

Moving/Copying worksheets with formulars 1
calculating a sum that contains a 0 or no data 6
Wrists Hurting!!! There has got to be a better way 6
Minimum formula the excludes zeros 3
activate formula when adjacent cell populated 4
Formula in a Macro 2
converting text to number 5
Copy VLOOKUP Formular but only change the Lookup_Value. 2

Top