Logical FunctionsIntermediate

NOT Function

Use NOT function to reverse logical values.

Task:

You are filtering a product list to exclude items in the Electronics category. Identify products that are NOT in the Electronics category in column C.

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.

    CoreIntermediate
  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.

6 rows × 3 columns5 cells you fill in
ABC
1ProductCategoryNot Electronics
2LaptopElectronics
3ChairFurniture
4PhoneElectronics
5DeskFurniture
6TabletElectronics
What this exercise teachesMay contain the answer

The NOT function reverses logical values, useful for finding opposite conditions or excluding specific criteria.