IFS

With the IFS function, you can check whether one or more conditions are met and returns a value that matches with the first TRUE condition.

Note: This feature only applies if you have an Office 365 subscription.

1. Choose the cell you want to create a IFS function from.
2. Enter =IFS(.
3. Set the first condition.
4. Create the other conditions.
5. Hit Enter.

Apply the IFS formula to the column

1. Enter $ to insert an absolute reference to a current IFS formula.
2. Drag to distribute this formula down in a column.