Munkykween
New Member
- Joined
- Jul 11, 2007
- Messages
- 4
I have a column of IF statements which produce a number depending upon the percentage that is entered into the column next to it. How do I have the column of IF statements average all of the numbers that are produced (out by a decimal and two places)? Each time that I try it gives me this: #DIV/0!
The IF statement is this: =IF(C9>89%,"4",IF(C9>79%,"3",IF(C9>69%,"2",IF(C9>59%,"1"))))
So it looks like this:
73% 2
68% 1
85% 3
#DIV/0!
I need #DIV/0! to have the average (which would be 2.00 in this case)
Thank you for your help this one is REALLY stumping me
The IF statement is this: =IF(C9>89%,"4",IF(C9>79%,"3",IF(C9>69%,"2",IF(C9>59%,"1"))))
So it looks like this:
73% 2
68% 1
85% 3
#DIV/0!
I need #DIV/0! to have the average (which would be 2.00 in this case)
Thank you for your help this one is REALLY stumping me