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

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