Loading

IF ELSE condition in SharePoint calculated column?

Rahul Shinday

How to achieve below code in calculated column?

if(Month = "Jan")
then MonInNum = 1
else if(Month = "Feb")
then MonInNum = 2
else if(Month == "Mar")
then MonInNum = 3

..................... up to December

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palaniappan10y ago
Accepted answer
=IF([Month]="Jan","1",IF([Month]="Feb","2",IF([Month]="Mar","3",IF([Month]="Apr","4",IF([Month]="May","5",IF([Month]="Jun","6",IF([Month]="Jul","7",IF([Month]="Aug","8",IF([Month]="Sep","9",IF([Month]="Oct","10",IF([Month]="Nov","11",IF([Month]="Dec","12","1"))))))))))))