I need to use a formula the grade and also use a nested IF function to compute t
ID: 3053919 • Letter: I
Question
I need to use a formula the grade and also use a nested IF function to compute the letter gradeThe example below shows you how to get started and you must add the formula for C & D grade to the example below.
Example: The nested if forumla must work for all grades A - F, regardless of what your grade may be. Example: =if(O4>=.90,"A",if(O4>=.80,"B",do this for the C & D grade,"F"))))
Grades-Edited View Zoom Formula Table Chart FA0B CSC 150_11 FA 08 Destiny Grades Digital Research Cover Letter Total Letter Last Name, First Name CTCS Test 1 Safety Paper Resume Test 2 E1 E2 Sylla PSC Internet Points Grade Grade Destiny Jules 10 96 10 28 10 142 0 10 10 10 10 336 10 150 10 10010 360 Total Possible Points 10 100 10 30 Instructions Merge and Center the Title, font should be 18, red, and Bold in cell A1 The subtitle should be your name Grades : EXAMPLE John Doe Grades Center row 3, font size is 11, font face is Calibri e your name in A4 and your grades in B4-N4 Type the information as shown in row 6 Use a formula to compute the Total Points Use a formula to compute the Total Possible Points (Total Possible Points should equal 360) Use a formula to compute the Grade Use a NESTED IF FUNCTION to compute he Letter Grade Save the File as Grades 4
Explanation / Answer
Solution: As given the cut- off for grade A is 0.90 and for grade B is 0.80, assuming the United State grading system in which the cutoff are:
Then the nested if formula = if(O4>=.90,"A",if(O4>=.80,"B",if(O4>=.70,"C",if(O4>=.6,"D","F"))))
Letter Grade Percentage GPA A 90%-100% 4.0 B 80%-89% 3.0 C 70%-79% 2.0 D 60%-69% 1.0 F 0%-59% 0.0