#DIV/0! errors
 

I am attempting to do an AVG function w/ the following formulas. And every
time I do it gives me the #DIV/0! error message. None of these are blank nor
do they have zero totals so I'm not sure why I keep getting the message. Do I
have the IF formulas entered incorrectly????

=IF(B7=99%,"5",IF(B795%,"4",IF(B790%,"3",IF(B7 85%,"2","1"))))

=IF(B9=0,"3",IF(B9=1,"2",IF(B9=2,"1")))

I have 4 of these I need to AVG. I would do a simple add/4 feature but some
are for months that haven't occured yet and I can't have 0 totals. So I need
to do AVG so the fields will be left blank or else it will mess up my YTD
avg. Hope this wasn't confusing.

#DIV/0! errors
 

Erin,

Try remove the quotes from your numbers. By using quotes, you are forcing
them to be text instead of numbers.

=IF(B7=99%,5,IF(B795%,4,IF(B790%,3,IF(B785%,2, 1))))

=IF(B9=0,3,IF(B9=1,2,IF(B9=2,1)))

Does that help?
Paul
--

"Erin Leva" wrote in message
...
I am attempting to do an AVG function w/ the following formulas. And every
time I do it gives me the #DIV/0! error message. None of these are blank
nor
do they have zero totals so I'm not sure why I keep getting the message.
Do I
have the IF formulas entered incorrectly????

=IF(B7=99%,"5",IF(B795%,"4",IF(B790%,"3",IF(B7 85%,"2","1"))))

=IF(B9=0,"3",IF(B9=1,"2",IF(B9=2,"1")))

I have 4 of these I need to AVG. I would do a simple add/4 feature but
some
are for months that haven't occured yet and I can't have 0 totals. So I
need
to do AVG so the fields will be left blank or else it will mess up my YTD
avg. Hope this wasn't confusing.

#DIV/0! errors
 

You haven't produced any numbers as results of your IF functions. You have
surrounded the figures with quote marks, which makes them text strings,
which evaluate to zero.
--
David Biddulph

"Erin Leva" wrote in message
...
I am attempting to do an AVG function w/ the following formulas. And every
time I do it gives me the #DIV/0! error message. None of these are blank
nor
do they have zero totals so I'm not sure why I keep getting the message.
Do I
have the IF formulas entered incorrectly????

=IF(B7=99%,"5",IF(B795%,"4",IF(B790%,"3",IF(B7 85%,"2","1"))))

=IF(B9=0,"3",IF(B9=1,"2",IF(B9=2,"1")))

I have 4 of these I need to AVG. I would do a simple add/4 feature but
some
are for months that haven't occured yet and I can't have 0 totals. So I
need
to do AVG so the fields will be left blank or else it will mess up my YTD
avg. Hope this wasn't confusing.