Get instant live expert help on how to find grade in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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
How to find the percentage ? The % of students whose Baseline Grade is between 4 and 9 out of ALL Baseline students
Solved by D. B. in 21 mins
Percentage calculation, to find the percent of students whose grade 4 and above in the english and math
Solved by D. D. in 18 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
=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