Get instant live expert help on I need help with grade formula in excel

“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

I need a formula to calculate the number of male/female student in a particular grade PK-6 grade. student have a gender column & grade column, how do I write the formula that give the answer of how many male or females in particular grade
Solved by B. U. in 12 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 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
=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 want to assign a grade level for each student in a spreadsheet based on their words per minute. The grade level designation is determined by comparing the student's WPMs with a table showing grade levels and top WPM for each grade. The student's WPM lands somewhere between the previous grade level max WPM and the max WPM of the grade level designation I'm trying to determine. How do I build a table and a formula to automatically determine each student's grade level?
Solved by I. E. in 24 mins