MS Excel IFS Formula

Use the IFS function to check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

IFS Formula

Use the IFS function to check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.

  1. Select the cell you want to create a IFS function from.
  2. Type =IFS(.
  3. Create the first condition.
  4. Add the other conditions.
  5. Press Enter.

IFS Formula Video

Apply the IFS formula to the column

  1. Type $ to add an absolute reference to an existing IFS formula.
  2. Drag to bring this formula down in a column.