Remove #DIV/0 from view

  • Thread starter Thread starter Ellen
  • Start date Start date
E

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
 
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.
 
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
 
=IF (ISERROR(YourFormula),"",YourFormula)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
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.


.
Click to expand...
 
Back
Top