=IF(E7>=80,"4",IF(E7>=75,"3.5",IF(E7>=70,"3",IF(E7>=65,"2.5",IF(E7>=60,"2",IF(E7>=55,"1.5",IF(E7>=50,"1",IF(E7<50,"0"))))))))
Embedded Files
Page updated
Google Sites
Report abuse
=IF(E7>=80,"4",IF(E7>=75,"3.5",IF(E7>=70,"3",IF(E7>=65,"2.5",IF(E7>=60,"2",IF(E7>=55,"1.5",IF(E7>=50,"1",IF(E7<50,"0"))))))))