Uploaded bydinesh takyar
Nested If Function In Excel
The document explains how to use a nested ‘if’ function in Excel to assign grades based on students' average marks. It outlines the criteria for grades 'A', 'B', 'C', and 'D' for respective score ranges, and specifies a default remark of 'work harder' for lower scores. The formula structure is demonstrated, emphasizing the importance of balanced parentheses in the function.
Nested If Function In Excel
- 1. Nested ‘IF’ functionin Excelbyfamilycomputerclub.comhttp://www.familycomputerclub.com
- 2. Click in cellH3 where we wish to find the ‘Grade’ of the student. We have input the individual marks, calculated the total marks and then the average.http://www.familycomputerclub.com
- 3. 2. We wishto assign grade ‘A’, ‘B’, ’C’ and ’D’ to students with marks greater than or equal to 90, 80,70 and 60 respectively. For all other students we assign ‘work harder’http://www.familycomputerclub.com
- 4. 3. The appliedformula has to read as follows: If G3, the average value, is greater than 90 then assign grade ‘A’; if G3 is greater than 80 then assign grade ‘B’ and so on.http://www.familycomputerclub.com
- 5. 4. Finally ifG3 does not meet any of the criteria values we assign the student the remark ‘work harder’http://www.familycomputerclub.com
- 6. =IF (G3>-90, “A”,IF (G3>=80, “B”,IF (G3>=70, “C”,IF (G3>=60, “D”, “WORK HARDER”))))We close as many brackets as we openTHENELSEThe first comma is read as ‘Then’ and the next comma is read as ‘else’http://www.familycomputerclub.com
- 7. Thanks for watching!Forany clarifications visithttp://www.familycomputerclub.comhttp://www.familycomputerclub.com