AND Conditions

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 6 of 28.

AND returns true only when every condition is true. Put it inside IF when a result requires several rules at once. A single failing condition makes the combined test false.

B2 contains 72, C2 contains 90.

Example: =IF(AND(B2>=60,C2>=80),"Pass","Review").

Both the score and attendance meet their thresholds, so the first label is returned.

Use AND when all requirements must hold.

The practice sheet highlights cells where you should enter formulas. The same formulas must work when the tests replace the input data.

Challenge

Easy

Score is in B2 and attendance percentage as a whole number in C2. In D2, return Pass only when score is at least 60 and attendance is at least 80; otherwise return Review.

Enter formulas in the highlighted output cells: D2. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.

Try it yourself

Sheet1