Thread: percentage?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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