Logical Functions
Intermediate

NOT with ISBLANK: has anything been entered?

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

Task:

Each supplier has to return a signed contract; its reference goes in column B when it arrives. In C2:C7 show Received when column B has anything in it, otherwise Chase.

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 × 3 columns6 cells you fill in
ABC
1SupplierContract refStatus
2Atlas FreightC-2207
3Bluewater
4Corbel PrintC-2211
5Delta Cleaning
6Ember CateringC-2215
7Fold Packaging
What this exercise teachesMay contain the answer

You could swap the IF's two answers and drop NOT, and the result would be the same. Writing it with NOT keeps the condition in the same order as the sentence — if something has been entered, it is received — which is easier to check later than a reversed IF.