#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...

excel

Formulas and Functions

OliverScheurich
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)

OliverScheurich

Gold Contributor

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)

asell1

Copper Contributor

Sep 07, 2023

Worked perfectly. Thank you!

Forum Discussion

#DIV/0! Error

Resources