I have a column of percentages(column B), and another column next to it(column C) that calculates grades from the percentages using this formula:

`=IF(B3>=0.8,"5",IF(B3>=0.7,"4",IF(B3>=0.6,"3",IF(B3>=0.5,"2","1"))))`

When I try to average all the grades(column C) I get a division by 0 error. Formula used to average:

`=AVERAGE(C3:C30)`

What is the problem here?

`=MATCH(B3,{0,0.5,0.6,0.7,0.8})`