Logical FunctionsBeginner

Logical Comparisons

Use logical comparison formulas to produce TRUE or FALSE results.

Task:

Enter a formula in column B that returns TRUE if the value in column A is positive, otherwise FALSE.

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.

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

5 rows × 2 columns4 cells you fill in
AB
1ValueIs Positive
28
3-3
412
5-7
What this exercise teachesMay contain the answer

Logical comparisons in Excel (like =A2>0) return TRUE or FALSE. These are fundamental for data validation and conditional logic.