SharePoint Name to Number

Question

I am trying to convert a name in a list to number I have a column with the title Name and it contains multiple name and I want to create a column which will take the name in the name column and change it to number, this formula works =IF(Name="Jhon","2") if I want to add more names, numbers it wont work for example, my formula is as follows.

=IF(Name ="Jhon","2")
=IF(Name ="Mike","1") 
=IF(Name ="Jane","3")

thanks.

question from:https://stackoverflow.com/questions/65939876/sharepoint-name-to-number

Answer 1

The formula should be like this:

=IF(Name ="Jhon","2", IF(Name ="Mike","1",IF(Name ="Jane","3")))

For more, you could refer to this article:

https://support.microsoft.com/en-us/office/if-function-7025be14-5665-43d0-af20-8293d1fe9d3a