|
|
Condition - Funtion AND
Page visited 13779 times
|
1. An AND condition is true if all the logical tests are true
It is written as such
|
|
|
Formule de la cellule
AND(logical 1; logical 2;...) |
|
|
|
|
|
|
|
|
2. A student is accepted if he has the more than 10 for its average and no result below 6.
|
|
|
|
|
|
|
|
|
3. The function AND will be written in two parts: The first corresponds to the average
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
4. The second part refers to all the results.
You write it as thus
|
|
|
Formule de la cellule
|
|
|
|
|
|
|
|
5. This means that we make a test on each cells and if all the results are greater than 5, the test is true.
If a single result is below 5, the result is false
|
|
|
|
|
|
|
|
|
6. The AND equation has the following writting
|
|
|
Formule de la cellule
AND(E2>=10,AND(B2>5,C2>5,D2>5)) |
|
|
|
|
|
|
|
|
7. The complete formula in column G has the following writting
|
|
|
Formule de la cellule
=IF(AND(F2>=10;<AND(B2>5;C2>5;D2>5;E2>5));"Pass";"Failed") |
|
|
|
|
|
|
|
|
|
