IFS
Tests several conditions in order and returns the value for the first one that is true.
Group: Logical
Syntax
IFS(test1, value1, [test2, value2], ...)Example
Exampleexcel
WeCodeAcademyWeCodeAcademyTests several conditions in order and returns the value for the first one that is true.
Group: Logical
IFS(test1, value1, [test2, value2], ...)