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

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:

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

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
--
Brevity is the soul of wit.


"kellyann" wrote:

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