percentage?
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
|