SharePoint Calculated List Column

Senior Member

Hi Everyone,

 

Please help, I have a calculated column which reads data from a column that contains numbers like 1, 2, 3, 4 etc..I want the calcualted column to check the current number and then assign a string.

 

The code is as follows:

=IF([Month (Calculated)]="1", "January","No date")
=IF([Month (Calculated)]="2", "February","No date")
=IF([Month (Calculated)]="3", "March","No date")
=IF([Month (Calculated)]="4", "April","No date")
=IF([Month (Calculated)]="5", "May","No date")
=IF([Month (Calculated)]="6", "June","No date")
=IF([Month (Calculated)]="7", "July","No date")
=IF([Month (Calculated)]="8", "August","No date")
=IF([Month (Calculated)]="9", "September","No date")
=IF([Month (Calculated)]="10", "October","No date")
=IF([Month (Calculated)]="11", "November","No date")
=IF([Month (Calculated)]="12", "December","No date")

 

Can anyone help with this nested if? Thank you

0 Replies