Try it!
Use the IFS function to check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
Note: This feature is only available if you have a Microsoft 365 subscription.
-
Select the cell you want to create a IFS function from.
-
Type =IFS(.
-
Create the first condition.
-
Add the other conditions.
-
Press Enter.
Apply the IFS formula to the column
-
Type $ to add an absolute reference to an existing IFS formula.
-
Drag to bring this formula down in a column.