Hi Hina,
Sure, I can help you with that. You can use the
function in Excel to assign grades based on the marks obtained by the students. Here's the formula you can use in cell D2:
Code:
=IF(C2=90,"A+",IF(C2=80,"B",IF(C2=70,"C",IF(C2=60,"D",IF(C2=50,"E","F")))))
This formula checks the marks obtained in cell C2 and assigns the appropriate grade based on the range mentioned in your question. You can then copy this formula and paste it in cells D3 to D14 (or as many rows as you have data).
Here are the steps to follow:
- Open your Excel sheet.
- Enter the marks obtained by the students in column C.
- Enter the formula mentioned above in cell D2.
- Copy the formula from cell D2.
- Select the range of cells where you want to apply the formula.
- Paste the formula in the selected range.
Best regards,
[Your Name]