Chapter 3 Making decisions ・ MISSION 11

Mission 11: Meet both conditions

📋 Mission list

Task

In D2, show “OK” if the score is 70 or more and the attendance is 90 or more, and “No” if not.

Select a range by dragging with the mouse or with the arrow keys while typing a formula. Type part of a function name and press Tab to complete it.

Chapter 3 ・ MISSION 11

Meet both conditions

In D2, show “OK” if the score is 70 or more and the attendance is 90 or more, and “No” if not.

Now
Goal

The tutorial is On. Change this in theMission list.

Functions used in this mission

Example formula: =IF(AND(B2>=70,C2>=90),"OK","No")

AND(…) returns TRUE when all conditions are met. As the first argument of IF, it means “if both are met”. For either one, use OR.

To practice one function at a time:Function drillExcel function list

* This is a simulation of Excel calculations and may differ in some ways from how Excel actually behaves.

* Some actions may not work depending on your browser environment (for example, shortcuts used by extensions).