Using IFS Functions
Use the IFS function to check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
Select the cell you want to create a IFS function from.
Type =IFS(.
Create the first condition.
Add the other conditions.
Press Enter.
Apply the IFS formula to the column
Type $ to add an absolute reference to an existing IFS formula.
Drag to bring this formula down in a column.
Source: Microsoft