Use the IFS function to check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
- 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.
Comments
0 comments
Please sign in to leave a comment.