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.
%d bloggers like this: