Excel 2003: Putting Zero in Formulas until First Figures Filled In

G

Guest

I have rows with formulas. No figures are put in the spread sheet yet but the
cells with formulas are reading "$0". How can I get the cell to be completely
blank (except for the formula, of course) until the figures are inserted?
 
G

Gord Dibben

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

Those are the basics to prevent a zero from showing up.

Your formulas will have to be adjusted, of course.


Gord Dibben MS Excel MVP
 
D

David Biddulph

If your formula is currently =2*A1, and you want the answer blank while A1
is blank, then use
=IF(A1="","",2*A1)
 

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

my formulas return a zero 3
FILTER CELLS CONTAINING FORMULAS 5
Please HELP!! 2
Ignoring non-filled formulas in average 6
Only adding certain numbers as filled in 1
Paste link 2
blank cells having no value 2
Insert rows and copy forumla above it 3

Top