D
DangerMouse114
If my formula result is the number 0 then i want the cell to remai
blank... is this possible?
blank... is this possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
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)
You can't make a formula blank a cell but you can make the cell appear
empty.
Example
=IF(A1+B1=0,"",A1+B1)
M
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
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
D
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
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
C
CLR
Tools > Options > View Tab............uncheck "Zero values"
Vaya con Dios,
Chuck, CABGx3
Vaya con Dios,
Chuck, CABGx3
P
Peo Sjoblom
Since average disregards text it should work
D
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.
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.
P
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)
=(A7+A8+A9)/A10
or
=SUM(A7:A9)/A10
How about
=IF(A10=0,"",(A7+A8+A9)/A10)
D
DangerMouse114
Thanks Ill try all these out when i get back to work
D
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
was with a result of 0 but I think the above answers will help me