Cell J4 contains total marks of student.What formula you will write in cell K4 to calculate result of student.If marks are greater than or equal to 300, student is pass.If marks are less than 300, student is fail.
Answers
Answer:
03-Dec-2014 — Column E will have the "Pass " mark if either the first score is ... As you see in the screenshot below, our students have a ..
Explanation:
please mark as brainllist
The Formula for Grade is the nested IF formula that checks certain criteria and returns the specific grade if the criteria is met. Finding the student grade is probably the basic example all the excel guides give to their students to explain the logic of logical functions in excel. IF, AND, OR, FALSE, TRUE, and IFERROR these are some of the famously used logical functions in excel.
Start Your Free Excel Course
Excel functions, formula, charts, formatting creating excel dashboard & others
In this article, we will explain the different ways of finding the grade for student score, employee efficiency level, bonus calculation and many other things using the Formula for Grade in Excel.
How to use Formula for Grade Calculation in Excel?
Let us understand how to use formula for Grade Calculations through some examples.
Each example will try to explore a different use case which is implemented using the Formula for Grade in Excel.
You can download this Formula for Grade Excel Template here – Formula for Grade Excel Template
Find Grades of Students: Nested IF Conditions
Finding students grade is one of the best examples to understand the logicality of the IF condition in excel. Consider the below students score for this example.
Grade Formula in Excel example 1-1
Below are the criteria for finding a grade.
If the score is above 550 Grade is A+
If the score is above 500 grade is A.
If the score is above 450 graded is B+
If the score is above 400 grade is B
If the grade is above 300 grade is C
IF the grade is not matching any of the above condition then grade will be FAIL.
In order to find an individual student grade, we need to test all these conditions and based on the conditions satisfaction we need to declare the grades.
Popular Course in this category
Sale
Excel Training (18 Courses, 9+ Projects)
18 Online Courses | 9 Hands-on Projects | 95+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.9 (6,201 ratings)
Course Price
₹1999 ₹19999
View Course
Related Courses
Excel Data Analysis Training (12 Courses, 8+ Projects)Excel for Finance Training (15 Courses, 7+ Projects)
By using IF condition we can find the grades here. Before I tell you how to find the grades let me explain IF condition first.
Grade Formula in Excel example 1-2
Logical Test: This is the argument to test the logic of the value.
Value if True: If the logical test is true what should be the result we want.
Value if False: If the logical test is false what should be the result we want.
Now take a look at the simple example.
Grade Formula in Excel example 1-3
Formula for Grade in Excel – Example #1
If the day is equal to SUNDAY then price should be 35 or else we need the price as 30.
Step 1: Open the IF condition in cell B2.
Grade Formula in Excel example 1-4
Step 2: Now we need to do the logical test i.e. whether the day is equal to SUNDAY or not. Select the cell A2 and test whether that is equal to SUNDAY or not.
Grade Formula in Excel example 1-5
Step 3: If the logical test is true then the result is 35.
Grade Formula in Excel example 1-6
Step 4: If the logical test is false result should be 30.
Grade Formula in Excel example 1-7
Step 5: Close the bracket and hit the Enter key. We have a result.
Grade Formula in Excel example 1-8
Step 6: Now we will drag this formula of cell B2 to the cell B3. So we will have a result as shown below.
Grade Formula in Excel example 1-9
Formula for Grade in Excel – Example #2
Now let’s apply this logic to find the grades of students by using Formula for Grade in Excel.
Step 1: Open the IF condition in C2 cell. First logical test is if the score is above 550. So test the score is >550 or not. If this test id TRUE value should be “A”.
Example 2-1
Step 2: If the test is false value should be??? Here we need to test a few more criteria’s. So open the new IF condition.
Example 2-2
Step 3: Now test the second criteria i.e. if the value is >500. If this logical test is true result should be “B+”.
Grade Formula in Excel example 2-3
Step 4: Now if both the conditions are FALSE we need to test the third criteria. So open one more IF condition and test whether the value is >400 or not. If the test is TRUE the result should be “B”.