“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=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]=W, 0)))

Solved by G. B. in 16 mins

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

I need help to create an excel calculator formula for settlement payment

Solved by F. W. in 30 mins

I need a formula for doing the grade points. For example grade : 2E , its grade point is 4, with a formula i want to convert all the grades to its relevant grade point and use it in other formulas

Solved by X. S. in 30 mins

I have created a formula with true and false however would like it to be $0 if the cells are blank.
=IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)

Solved by O. E. in 12 mins