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