Forum Discussion

asell1's avatar
asell1
Copper Contributor
Sep 07, 2023
Solved

#DIV/0! Error

I have a spreadsheet of grades that require a scaled score. The original sheet is downloaded from our textbook computer program. I have added a line under the raw score to create a row of scaled scor...
  • OliverScheurich's avatar
    Sep 07, 2023

    asell1 

    =IF(C8="Not Started", " ", IF(C8="In Progress", " ", IF(C8>81, 100, IF(C8>=61, 93, IF(C8>=41, 85, IF(C8>=21, 75, IF(C8>=1, 60, IF(C8=0, 50))))))))

     

    In the attached example i've entered this formula in C9 and filled across C9:L9. The average formula in cell M9 returns the intended result. I've changed e.g.   "85" to 85 because  "85" is a text value and 85 is a number value which can be used for calculation.

     

    =AVERAGE(C9:L9)

     

Resources