Please help!

[DangerMouse114]

If my formula result is the number 0 then i want the cell to remai
blank... is this possible?

 

[Norman Harker]

Hi DangerMouse14!

You can't make a formula blank a cell but you can make the cell appear
empty.

Example

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

 

[Michael]

Hey Danger Mouse

Firstly, Relax......one post would have probably got the
desired result.
What formula are you using now??
If your using a percent formula eg A2/A1,
you could use =IF(A2/A1=0,"",A2/A1)
but there are many and varied answers.
Regards
Michael

 

[DangerMouse114]

Thanks!

Hopefully this works.

The reasion i need it to do this is because all the cells that equa
"0" are messing up my average of cells with values higher then 0

 

[CLR]

Tools > Options > View Tab............uncheck "Zero values"

Vaya con Dios,
Chuck, CABGx3

 

[Peo Sjoblom]

Since average disregards text it should work

 

[DangerMouse114]

the formula im using is this:

D1=A7+A8+A9/A10 = 5-10-2004
E1=A7+A8+A9/A10 = 5-11-2004
F1=A7+A8+A9/A10 = 5-12-2004

A10 is the total of A1-A9.

Thus D1 is giving me the percentage of the total number added up within
the A1-A9 range.

The problem is that D1, E1, F1 are then averaged themselves. But if i
have not yet entered in numbers for F1 because the numbers will be from
the next day F1 ends up being 0 and messing up my average of D1 and
E1.. the formula is of course much larger then this but you get the
idea.

 

[Peo Sjoblom]

I you want to divide the sum of A7:A90 with A110 you must use

=(A7+A8+A9)/A10

or

=SUM(A7:A9)/A10


How about

=IF(A10=0,"",(A7+A8+A9)/A10)

 

[DangerMouse114]

Thanks Ill try all these out when i get back to work

 

[DangerMouse114]

Peo I know i have to write those formulas to add a7 a8 and a9 my proble
was with a result of 0 but I think the above answers will help me