Assign letter Grade in Column F using the following policy in Excel-2007
Assign letter Grade in Column F using the following policy:
Average score Grade | |
80 or more | A |
65 to 79.99 | B |
Less than 65 | C |
To assign letter grade in column F,
Enter the formula,
=IF(E2>=80,”A”,IF(E2>=65,”B”,”C”)) in cell F2 and then press enter key,
using the fill handle of cell F2, copy the formula to cells F3 :F6
by dragging the fill handle up to cell F6 .
0 comments:
Post a Comment