Ledger DrillBeta
Log inJoin for free

Making decisions

Make a sheet decide for itself: show one thing or another with IF, join tests with AND and OR, and flag the invoices that are overdue.

Premium5 rooms41 questions45 min
See the first roomHow IF works

Rooms in this module

  1. How IF works8 min, easyPremium
  2. IF with AND and OR9 min, easyPremium
  3. Nested IF for three or more outcomes9 min, mediumPremium
  4. IFERROR: what to show when a formula fails9 min, mediumPremium
  5. Flagging overdue invoices10 min, mediumPremium

How this works

Each room answers one problem. A task is a few lines of reading, then questions you answer in the books: post to an account, type a figure, sort, match or write a journal. Every answer is marked at once, with the rule behind it. There are no videos.

Questions

How many rooms and questions are in Making decisions?

5 rooms and 41 questions. Every question is marked at once.

How long does it take?

About 45 minutes in all. A room takes 8 to 10 minutes, so you can do one at a time.

Is it free?

No. These rooms need Premium. Each room shows the start of its first task before you pay.

What should I do first?

Everyday functions. It is the module before this one in Spreadsheets for the office.