OR Conditions

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

OR returns true when at least one condition is true. It is also true when several conditions are true. Use it for alternative ways to qualify.

B2 contains 40, C2 contains yes.

Example: =IF(OR(B2>=100,C2="yes"),"Free","Paid").

The membership condition is true even though the amount is below 100.

Use OR when any one of several conditions is sufficient.

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

Challenge

Easy

Order amount is in B2; membership text yes or no is in C2. In D2, return Free if the amount is at least 100 or membership is yes; otherwise return Paid.

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