#DIV/0! errors

[Erin Leva]

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(B7>95%,"4",IF(B7>90%,"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.

 

[PCLIVE]

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(B7>95%,4,IF(B7>90%,3,IF(B7>85%,2,1))))

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

Does that help?
Paul

 

[David Biddulph]

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.