How can i write a IF statement that allows me to change Aliases for multiple items in a column A as output in Column B also that all of the below names are from Electrical and Mechanical Department DepartmentColumn A Column B Electrical Adrian Adi Mechanical Jack Jackers Electrical Shane Sha ElectricalJennyJeniffer MechanicalJadeJa I have written a statement like this IF [Department] ='Electrical' and [Column A] =' Adrian' then 'Adi' elseif [ Department ] = 'Electrical' and [Coloumn A] = ' Shane' and 'Sha' elseif [Department] ='Mechanical' and [Column A] = 'Jade' then 'Ja' else [NULL] endif its not working somehow i am using the formula tool for this purpose

How can i write a IF statement that allows me to change Aliases for multiple items

How can i write a IF statement that allows me to change Aliases for multiple items in a column A as output in Column B also that all of the below names are from Electrical and Mechanical Department

Department	Column A	Column B
Electrical	Adrian	Adi
Mechanical	Jack	Jackers
Electrical	Shane	Sha
Electrical	Jenny	Jeniffer
Mechanical	Jade	Ja

I have written a statement like this

IF [Department] ='Electrical' and [Column A] =' Adrian' then 'Adi' elseif [ Department ] = 'Electrical' and [Coloumn A] = ' Shane' and 'Sha' elseif [Department] ='Mechanical' and [Column A] = 'Jade' then 'Ja' else [NULL] endif

its not working somehow i am using the formula tool for this purpose

Run Command

Accepted answers

Jean-Balteryx

Hi @ahsansalik ,

If you copy pasted your formula then there is a typo :

IF [Department] ='Electrical' and [Column A] =' Adrian' then 'Adi' elseif [ Department ] = 'Electrical' and [Coloumn A] = ' Shane' THEN 'Sha' elseif [Department] ='Mechanical' and [Column A] = 'Jade' then 'Ja' else [NULL] endif