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.
- Choose the cell you want to create a IFS function from.
- Enter =IFS(.
- Set the first condition.
- Create the other conditions.
- Hit Enter.
Apply the IFS formula to the column
- Enter $ to insert an absolute reference to a current IFS formula.
- Drag to distribute this formula down in a column.