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!