Assign numeric value to various job titles

[95Bigbluetoy]

I need to assign a numeric value to various job titles. I can use the IF statement to make this work for two titles, but i have about a dozen various job titles that i need to assign a value to and havent been able to figure out how to accomplish this. Some of the titles will have the same value. For instance, i need PMs to have a value of 5,  whereas Superintendents, Foreman and Field Engineers will have a value of 0. APMs will have a value of 2 and VPs will have a value of 75, etc.

Any and all help is greatly appreciated.

[v-diye-msft]

Hi @95Bigbluetoy 

Not quite understand your requirement, could you please post some captures to clarify more details?

[95Bigbluetoy]

Thanks for responding. what i am looking to do is to assign a numeric value to various job titles so as to then use that value in another calculation. I can use the IF statement to say that 

IF([Title]= "SUPERINTENDENT", "0", IF([Title]= "VICE PRESIDENT", "90")), but i have numerous job titles to assign a value to.

my data table has a column "Title", so what i am looking for is to add a new column that has a value based on the job title. here is an example of what i am looking for:

Title	Value
Superintendent	0
Project Manager	5
Assistant Project Manager	2
Project Manager Assistant	90
Vice President	75
Assistant Superintendent	0
General Superintendent	5

[v-diye-msft · Accepted solution]

Hi @95Bigbluetoy 

If the value is exactly defined by the title name, you need to use IF/SWITCH function to do it. such as write to: IF([Title]= "SUPERINTENDENT", "0", IF([Title]= "VICE PRESIDENT", "90"))..one by one. there's no easy way to do this.  probably SWITCH function can be simpler than IF.

[95Bigbluetoy]

thanks for the input. I didnt know that i could keep using the IF statement for the number of times i needed within the same equation. It is working.