|
|
Condition - Funtion OR
Page visited 21749 times
|
1. The result of the function is TRUE when only one test (argument) is true
It is written as follows
|
|
|
Formule de la cellule
OR(logical 1; logical 2;...) |
|
|
|
|
|
|
|
|
2. In the next example, A student passes if he has had at least 12 in the second exam and at least an average bigger than 10
|
|
|
|
|
|
|
|
|
3. So, we start to write to begin of the formula OR and we write the first logical test
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
4. And we finished the function with the test of the average
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
5. And so, for this example, the complete formula is
|
|
|
Formule de la cellule
=IF(OR(C2>=10,E2>=12),"Pass";"Failed") |
|
|
|
|
|
|
|
|
6. You can check that even if have the same average, .... passed her exam because
|
|
|
|
|
|
|
|
|
|
