How to use Calculated Column in Sharepoint

Hello All,

This post represents the example of Calculated Column in SharePoint.

I’ve created sample SharePoint list with two fields (i.e. MarkObtained & Grade). The field “Grade” is considered as a Calculated Column. Below is my requirement.

If MarkObtained >= 70 then Grade would be “Distinction”
If MarkObtained <>= 60 then Grade would be “First Class”
If MarkObtained <>= 50 then Grade would be “Second Class”
If MarkObtained <>= 40 then Grade would be “Pass Class”

For Calculate Field (i.e. Grade), I need to write formula based on “Marks Obtained” field’s value. Please find the correct formula below:

If MarkObtained >=70,"Distinction",
(IF (AND (MarkObtained<70,>=60),"First Class",
(IF (AND (MarkObtained<60,>=50),"Second Class",
(IF (AND (MarkObtained<50,>=40),"Pass Class","Fail")))))))

This way we can get value in the “Grade” field based on calculation of “MarkObtained”.