Description
Check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
NOTE
- The [logical_test] can be a number[s] or boolean[s].
- The number of parameters is even, the [value_if_false] argument does not exist but can be created by adding a pair of parameters with the logic equal to TRUE at the end.
Syntax
Copied!=IFS(logical_test1, value_if_true1, logical_test2, value_if_true2, ...)
SAMPLE data
| | A | B | C | D | E |
|:---:|:----|:-------|:------|----:|:----|
| 1 | | | | | |
|-----|-----|--------|-------|-----|-----|
| 2 | | | | | |
|-----|-----|--------|-------|-----|-----|
| 3 | | Orange | Pink | 1 | |
|-----|-----|--------|-------|-----|-----|
| 4 | | Apple | Red | 2 | |
|-----|-----|--------|-------|-----|-----|
| 5 | | Lemon | Green | 3 | |
|-----|-----|--------|-------|-----|-----|
| 6 | | | | | |
|-----|-----|--------|-------|-----|-----|
| 7 | | | | | |
|-----|-----|--------|-------|-----|-----|EXAMPLE 1
Copied!=IFS(D3:D5>100, "LARGE", D3:D5>20, "MEDIUM", TRUE, "SMALL")
| | A |
|:---:|:------|
| 1 | SMALL |
|-----|-------|
| 2 | SMALL |
|-----|-------|
| 3 | SMALL |