Remove #DIV/0 from view

[Ellen]

I have designed an attendance tracking sheet which
calculates the % attendance with the following formula: Sum
(B9:F9)/Counta(B9:F9). When no information has been keyed
in, the following appears in the cell: #DIV/0. Is there a
way to remove the #DIV/0? It can be a bit confusing for
non-techies.

Thank you in advance.

Ellen

 

[J.E. McGimpsey]

On way:

IF(COUNTA(B9:F9), SUM(B9:F9)/COUNTA(B9:F9),"")

If COUNTA(B9:F9) > 0 then the condition will be interpreted as TRUE,
and the calculation will be performed.

 

[PTT, Inc.]

You can do a simple IF statement like:

=IF(B9,put your formula here,"")

Which basically says if there is something in B9 do the calculation
otherwise leave it blank (double quotes). There are other ways, but this is
simple enough to use. You can copy down the formula as well.

Bill Foley
www.pttinc.com

 

[Niek Otten]

=IF (ISERROR(YourFormula),"",YourFormula)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Thanks! It works BEAUTIFULLY!

-----Original Message-----
On way:

IF(COUNTA(B9:F9), SUM(B9:F9)/COUNTA(B9:F9),"")

If COUNTA(B9:F9) > 0 then the condition will be interpreted as TRUE,
and the calculation will be performed.


.