#DIV/0! errors

  • Thread starter Thread starter Erin Leva
  • Start date Start date
E

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if true, if not nested if funcion 2
I hate the DIV/0! error! Can anyone help me make this go away? 5
Excel Help to copy information from one row at a time to another sheet 1
Taking Average ignoring #DIV/0! in the range... 1
SumIf conditional to date range 5
SUMPRODUCT with multiple criteria 9
SORT data containing formula 5
Supress DIV/0 2

Back
Top