IFS Function Explained
The IFS function in Microsoft Excel is used to test multiple conditions at the same time and returns a value that corresponds to the first true condition. It takes up to 127 arguments, each of which is a logical expression that evaluates to either TRUE or FALSE. If the first argument is TRUE, the function returns the value in the corresponding second argument; if the first argument is FALSE, the function evaluates the second argument and so on. If none of the arguments are TRUE, the function returns the value in the last argument.
IFS Function Syntax
IFS(logical_test1, value1, [logical_test2, value2], ...)
- logical_test1: The first condition that you want to test that returns either TRUE or FALSE.
- value1: The value that is returned if the logical_test1 argument evaluates to TRUE.
- logical_test2: (optional) The second condition that you want to test that returns either TRUE or FALSE.
- value2: (optional) The value that is returned if the logical_test2 argument evaluates to TRUE.