Logical Functions
Beginner

Spot differences with <>

Not equal to: the comparison a reconciliation is built on.

Task:

You counted the shelves and the stock system has its own figures. In D2:D7 return TRUE for every line where the count and the system disagree, so you know which ones to recount.

Interactive Spreadsheet

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 Logical Comparisons

0/3

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

  1. Logical Comparisons

    Use logical comparison formulas to produce TRUE or FALSE results.

    Core
    Beginner
  2. Compare text with =

    A comparison works on words as well as numbers — and ignores capital letters.

    Beginner
  3. Spot differences with <>

    Not equal to: the comparison a reconciliation is built on.

    Beginner

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
1ItemSystemCountedMismatch?
2Hinges240240
3Brackets115112
4Wall plugs800800
5Screws15001480
6Washers600600
7Nuts950965
What this exercise teachesMay contain the answer

Subtracting the two columns tells you by how much they differ, but a TRUE/FALSE column is what you filter on to get the recount list. <> is the comparison for that: it asks the yes-or-no question directly.