If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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. |
#2
|
|||
|
|||
#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. |
#3
|
|||
|
|||
#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. |
Thread Tools | |
Display Modes | |
|
|