NOT Conditions

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

NOT reverses one logical result. For example, NOT(B2="Closed") is true when the status is not Closed. It is useful inside larger rules when a condition must not hold.

B2 contains Pending.

Example: =IF(NOT(B2="Closed"),"Open","Done").

The status is not Closed, so NOT reverses the false comparison to true.

NOT accepts one logical expression and reverses its truth value.

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

Challenge

Easy

Status in B2 is Closed or another nonempty text. In C2, return Open when the status is not Closed; return Done otherwise. Use NOT.

Enter formulas in the highlighted output cells: C2. 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