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.

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.

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.