Forum Discussion
asell1
Sep 07, 2023Copper Contributor
#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...
- Sep 07, 2023
=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)
OliverScheurich
Sep 07, 2023Gold Contributor
=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)
- asell1Sep 07, 2023Copper ContributorWorked perfectly. Thank you!