Excel Function: IFS
Use IFS to check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS can take the place of nested IF statements.
EXAMPLE:
NOTES:
- To specify default result, enter TRUE for final logical_test. If no other conditions are met, the corresponding value will be returned.
- If a logical_test argument is supplied without corresponding value_if_true the result will be "You've entered too few arguments for this function" error
- If a logical_test argument is evaluated and resolves to a value other than TRUE or FALSE the result will be #VALUE! error
- If no TRUE conditions are found the result returns #N/A error