I need this formula to run in column K, calculated off of column j
=IF([@GRADE]= “I”, 0,IF([@GRADE]= “U”, 0,IF([@GRADE]= “A”, 4,IF([@GRADE]= “B”, 3,IF([@GRADE]= “C”, 2,IF([@GRADE]= “D”, 1,IF([@GRADE]= “F”, 0,IF([@GRADE]= “WC”, 0,0, IF([@GRADE]= “P”, 2)))))))))
Solved by A. A. in 17 mins