Page 69 - Penta Book's ICT Catalogue

IF and AND together

IF the orals grades are greater than or equal to 55 AND the test grades are greater
than or equal to 55, then the student will pass, otherwise, the student will fail.

To combine a multiple IF with AND:

> Click H3.
> In the Formula bar, type =IF((AND(B3>=55,C3>=55)),”pass”, “fail”). 1

> Press Enter  . 2

> Click the fill handle 3 and use the Autofill tool to fill the rest of the cells. 4

Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5 1

8
/ Functions / Functions 2
5. Analyzing data / Functions
5. Analyzing data / Functions
GRADE 3

4

SMART TIP

Many countries use a comma as a decimal separator, while
others use a dot. Find which decimal separator is used in your
68 country here: http://en.wikipedia.org/wiki/Decimal_mark
Penta Books