How do you get rid of 0 when data not in formula row yet?

J

Joe

try

=IF(formula=0, [spacebar], formula)

and by [spacebar], I mean just leave it empty
 
S

samerry

I have copied a formula down several rows for future data to be entered and
calculated. In the formula column it shows "0". I would like for the "0" not
to show. Does anyone know how to make the "0" go away without deleting the
formula. Data will later be entered in the appropriate rows and need to be
calculated at the appropriate time.
 
P

PCLIVE

You could also use Joe's formula, but I believe you'll need to use a two
double quotes instead of a space.

=IF(formula=0,"",formula)
 
P

PCLIVE

Yes,

Example:

=IF(SUM(A1:A3)=0,"",SUM(A1:A3))

This basically states that if your formula results "0", then the cell
remains blank, otherwise display the results of your formula.

Paul
 
P

Pasko1

Go into Tools--Options--View and uncheck Show Zero Values. This should work.
I use it all the time in complex pivot tables, etc.
 
C

Chris Lavender

You could use Tools...Options...View and uncheck the Zero Values box, but
that may not be what you want if you need to see zero values when the data
is entered...
 
S

Sloth

Also Custom format works like this...

Postive numbers;Negative Numbers;Zero

So if you want it to show decimal points, then you would need something like
this as a custom format...

#.00;#.00;""

If you are dealing with whole numbers, this isn't necessary and # by itself
will be appropiate.
 
Top