|
|
Condition - Imbricated Condition
Page visited 30212 times
|
1. Sometimes, you should have not only 2 results but, 3, 4, 5 ......
|
|
|
|
|
|
|
|
|
2. And then, the formula has the following writing
|
|
|
|
|
|
|
|
|
3. In our example, we are going to write according to the average
- "Failed" if the average is less than 10
- "Accepted" if the result is between 10 and 12
- "Good" if the result is between 12 and 14
- "Very Good" if the result is between 14 and 16
- "Excellent" if the result is greater than 16
|
|
|
|
|
|
|
|
|
4. So, you start by the first test (average below 10)
|
|
|
Formule de la cellule
=SI(E2<10;"Failed"; ...... |
|
|
|
|
|
|
|
|
5. And, in stead of writing a result for the case if the average is not less than 10, we have to write a new condition for the case where the result is between 10 and 12
|
|
|
Formule de la cellule
=SI(E2<10;"Failed";SI(E2<12;"Pass"; |
|
|
|
|
|
|
|
|
6. And so forth for the other tests and you have the following formula.
Look at the parenthesis at the end of the formula to close all the test ; one for each test
|
|
|
|
|
|
|
|
7. You can insert a line break by pressing ALT + Enter. This has no consequence on the result of your function
|
|
|
Formule de la cellule
<b>ALT</b> + <b>Enter</b> |
|
|
|
|
|
|
|
|
|
