Get instant live expert help on I need help with excel grade calculator

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

=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