@excelhub.bsky.social
December 2, 2024 at 11:48 AM
December 2, 2024 at 11:47 AM
Excel Trk: Assigning Student Grades
To assign grades based on student scores in Excel, use the XLOOKUP function. For example, if scores of 90+ get an "A," 80-89 get a "B," 70-79 get a "C," and below 70 get a "D," you can use this formula: =XLOOKUP(B2, {0, 70, 80, 90}, {"D", "C", "B", "A"}, , -1)
To assign grades based on student scores in Excel, use the XLOOKUP function. For example, if scores of 90+ get an "A," 80-89 get a "B," 70-79 get a "C," and below 70 get a "D," you can use this formula: =XLOOKUP(B2, {0, 70, 80, 90}, {"D", "C", "B", "A"}, , -1)
December 2, 2024 at 11:45 AM
Excel Trk: Assigning Student Grades
To assign grades based on student scores in Excel, use the XLOOKUP function. For example, if scores of 90+ get an "A," 80-89 get a "B," 70-79 get a "C," and below 70 get a "D," you can use this formula: =XLOOKUP(B2, {0, 70, 80, 90}, {"D", "C", "B", "A"}, , -1)
To assign grades based on student scores in Excel, use the XLOOKUP function. For example, if scores of 90+ get an "A," 80-89 get a "B," 70-79 get a "C," and below 70 get a "D," you can use this formula: =XLOOKUP(B2, {0, 70, 80, 90}, {"D", "C", "B", "A"}, , -1)