Forum Discussion

SpeaksKM's avatar
SpeaksKM
Copper Contributor
Sep 05, 2024

IFS, is there another way?

To weight tests I have this sheet of composite scores that correspond to a test grade.

Is there a way to enter a student's composite score and have Excel spit out the grade without doing IFS for every single possibility? The sheet continues down to 25 and I really don't want to have to type all those conditions.

Resources