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.

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.


Source: Microsoft