Lesson 5 , More about Results formula || very interesting
0:00 / 0:00
Lesson 5 , More about Results formula || very interesting
28
28
In this tutorial, you will learn how to create an advanced subject-wise student result sheet in Microsoft Excel. Unlike the total-marks calculation, this video covers a detailed formula using the Nested IF function to automatically determine whether a student has passed or failed in each individual subject based on specific passing marks (e.g., 35 or 45).
Perfect for teachers, school administrators, and Excel learners who want to automate their grading systems efficiently!
📌 What you will learn:
How to set passing criteria for individual subjects in Excel.
Using logical functions (IF) for result automation.
Formatting result sheets professionally for clean data presentation.
Don't forget to Like, Share, and Subscribe for more useful Excel tutorials and shortcut tips!
