Basic Functions
Advanced

QUOTIENT rounded up: how many pages?

Whole division that rounds up, using nothing but QUOTIENT.

Task:

A report prints a fixed number of rows per page. In D2:D6 give the number of pages each section needs — a section that spills one row onto a new page still needs that page.

Interactive Spreadsheet

Read about QUOTIENT

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 QUOTIENT

0/3

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

  1. QUOTIENT Function

    Find the integer portion of division using QUOTIENT.

    Core
    Intermediate
  2. QUOTIENT for mixed units

    Total inches into feet and inches, the way a tape measure reads.

    Intermediate
  3. QUOTIENT rounded up: how many pages?

    Whole division that rounds up, using nothing but QUOTIENT.

    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 × 4 columns5 cells you fill in
ABCD
1SectionRowsRows per pagePages
2Sales12040
3Stock12140
4Staff1525
5Suppliers5025
6Assets130
What this exercise teachesMay contain the answer

QUOTIENT always rounds down, so the -1/+1 shift turns it into rounding up for whole numbers. It is worth knowing because it is exact with no floating-point edge cases; CEILING(B2/C2,1) gets the same answer and reads more plainly, which is why it is the one you will see most.