percentage?

K

kellyann

my question is i am trying to find the percent of an average. ( i have a
spread sheet of 14 people) I am trying to
get an 'average' percent of all their combined percentages. WHen some
employees are not at work then i leave thoese colums blank and i receive an
erro # DIV/O! and my percent total at the bottom, also reflects the same
error. I'm sorry if i'm confusing, but right now i'm confused myself! Please
helpt
 
M

Marcelo

hi,

try to solve the #div/0! error using
=if(iserror(YOUR FORMULA),0,YOUR FORMULA)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"kellyann" escreveu:
 
D

Dave F

Well dividing by zero yields the empty set, which Excel can't handle, so you
need to trap errors, by doing something like =IF(ISERROR(A1/B1),"",A1/B1) and
then average on that column of calculations.

AVERAGE ignores blank values but doesn't know what to do when it encounters
error values.

Dave
 
Top