Forum Discussion
Excel formula question
I have built a spreadsheet for a school to record the students' attendance in hours and their grades. In this school, if the student fails the class, he/she is not entitled to the hours. How can I mo...
beckjohn In general terms you would sum the hours and multiply it by 1 if the grade is not equal to "F", otherwise multiply by 0.
Such a formula would look like: =SUM(hours)*(grade<>"F")
Demonstrated in the picture below. Formula entered in B6 (as shown in C6).