Logical Functions
Advanced

NOT inside AND: all of these, but not that

Combine a positive condition with an exception.

Task:

A customer can place an order when their account is Active and is not flagged On hold by credit control. In D2:D7 show Allowed or Blocked.

Hints

+5 XPno-hints bonus

Solve it on your own to keep the bonus. Each hint gets one step closer to the formula.

Variations of AND, OR, NOT

0/3

The same formula in the other shapes it takes at work.

  1. NOT Function

    Use NOT function to reverse logical values.

    Core
    Intermediate
  2. NOT with ISBLANK: has anything been entered?

    The opposite of empty, as a test you can read.

    Intermediate
  3. NOT inside AND: all of these, but not that

    Combine a positive condition with an exception.

    Advanced

The data in this exercise

This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.

7 rows × 4 columns6 cells you fill in
ABCD
1CustomerAccountCredit flagOrdering
2Harbour InnsActiveClear
3Isle RetailActiveOn hold
4Jet MotorsClosedClear
5Kestrel LabsActiveReview
6Linden HotelsClosedOn hold
7Maple FoodsActiveClear
What this exercise teachesMay contain the answer

Listing the flags that are allowed (Clear, Review…) breaks the day credit control invents a new one. Naming the single flag that blocks — and negating it — means every other flag is allowed by default, which is what the rule actually says. Kestrel Labs, on Review, can still order.