The IFS function in Google Sheets allows you to evaluate multiple conditions and return the first true result. This can be useful when you want to perform different actions based on multiple conditions and return the result of the first condition that is met.
Here’s how to use the IFS function:
- In the cell where you want to display the result of the IFS function, enter the formula: =IFS(condition1, result1, [condition2, result2], …)
- Replace “condition1” with the first condition that you want to evaluate.
- Replace “result1” with the value or formula that you want to return if condition1 is true.
- Repeat steps 2 and 3 for each additional condition that you want to evaluate.
Here’s an example of how to use the IFS function:
=IFS(A1>5, “high”, A1>3, “medium”, A1>0, “low”, “negative”)
This formula compares the value in cell A1 to the values 5, 3, and 0. If the value in cell A1 is greater than 5, the formula returns “high”. If the value is greater than 3 but not greater than 5, the formula returns “medium”. If the value is greater than 0 but not greater than 3, the formula returns “low”. If the value is not greater than 0,