Nested IF error

ZennerJ

Can someone tell me where to place the last [value false] information on this very long formula? I'm having issues with it always showing the last true value (20) for the false values (School Missing) or an error message when I move it to a different spot on the ending parends:

=IF([Grading Scale]@row = "50", 2, IF([Grading Scale]@row = "50 Extended", 2, IF([Grading Scale]@row = "50 MZA", 3, IF([Grading Scale]@row = "60", 4, IF([Grading Scale]@row = "70", 5, IF([Grading Scale]@row = "Custom - 1120", 6, IF([Grading Scale]@row = "Custom - 1124", 7, IF([Grading Scale]@row = "Custom - 1130", 8, IF([Grading Scale]@row = "Custom - 1132", 9, IF([Grading Scale]@row = "Custom - 1136", 10, IF([Grading Scale]@row = "Custom - 1142", 11, IF([Grading Scale]@row = "Custom - 1145", 12, IF([Grading Scale]@row = "Custom - 1146", 13, IF([Grading Scale]@row = "Custom - 1159", 14, IF([Grading Scale]@row = "Custom - 1161 ", 15, IF([Grading Scale]@row = "Custom - 1246", 16, IF([Grading Scale]@row = "Custom - 1307", 17, IF([Grading Scale]@row = "Custom - 1472", 18, IF([Grading Scale]@row = "Custom - 1473", 19, IF([Grading Scale]@row = "Custom - 1609", 20, "School Missing"))))))))))))))))))))

Thank you!

Christina09

Hi @ZennerJ

I tried to recreate the column and value, it seems like it's just missing " " for the true value. If it didn't meet the criteria, it will return "school missing"

Try this:

=IF([Grading Scale]@row = "50", "2", IF([Grading Scale]@row = "50 Extended", "2", IF([Grading Scale]@row = "50 MZA", "3", IF([Grading Scale]@row = "60", "4", IF([Grading Scale]@row = "70", "5", IF([Grading Scale]@row = "Custom - 1120", "6", IF([Grading Scale]@row = "Custom - 1124", "7", IF([Grading Scale]@row = "Custom - 1130", "8", IF([Grading Scale]@row = "Custom - 1132", "9", IF([Grading Scale]@row = "Custom - 1136", "10", IF([Grading Scale]@row = "Custom - 1142", "11", IF([Grading Scale]@row = "Custom - 1145", "12", IF([Grading Scale]@row = "Custom - 1146", "13", IF([Grading Scale]@row = "Custom - 1159", "14", IF([Grading Scale]@row = "Custom - 1161 ", "15", IF([Grading Scale]@row = "Custom - 1246", "16", IF([Grading Scale]@row = "Custom - 1307", "17", IF([Grading Scale]@row = "Custom - 1472", "18", IF([Grading Scale]@row = "Custom - 1473", "19", IF([Grading Scale]@row = "Custom - 1609", "20", "School Missing"))))))))))))))))))))