Loading…
Loading…
IFS checks conditions in order and returns the first TRUE match.
=IFS(test1, value1, [test2, value2], …)
| Argument | Required? | What it is |
|---|---|---|
| test1 | Required | The first condition. Each condition is followed by the value to return when it is TRUE. |
| value1 | Required | The first value, cell or range. |
| test2 | Required | The next condition and value (optional). |
| value2, … | Required | More values (optional). |
=IFS(B2>=80,"A",B2>=60,"B",B2>=50,"C",TRUE,"F")
From the lesson IFS Function.
Type the formula yourself and get it graded instantly, no Excel needed.