Page 67 - Penta Book's ICT Catalogue

To make multiple IF a little more complex than the previous one, let’s add a multiple
IF on cell D3 of the sheet2 which will show the following:
If the total score is equal to or greater than 18, then the team will take a gold medal,
when (=else if) the score is more than 15, then the team will take a silver medal,
when (=else if) the score is more than 10, then the team will take a bronze medal,
and if it’s under 10 (=else), the team will not take a medal.

To add Multiple IF:

> Click cell D3 of sheet2.
> In the Formula bar, type =IF((B3+C3)>=18,”gold”,(IF((B3+C3)>=15,”si
lver”,IF((B3+C3)>=10,”bronze”,”no”)))). 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 3
5. Analyzing data / Functions
5. Analyzing data / Functions
GRADE

4

Keep in mind that in the
criteria boxes you can
type a single word or a
small phrase, or you can
do complex calculations
and even use other
functions as well.

66 Penta Books