Basic Functions
Intermediate

QUOTIENT for mixed units

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

Task:

Timber lengths are recorded in inches but the yard reads them in feet and inches. In C2:C6 show each length as, for example, 7 ft 4 in.

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 × 3 columns5 cells you fill in
ABC
1BoardInchesLength
2Oak88
3Pine96
4Ash15
5Beech143
6Cedar11
What this exercise teachesMay contain the answer

Dividing 88 by 12 gives 7.33, which is neither 7 ft 3 in nor 7 ft 4 in until you work out the fraction. QUOTIENT discards the fraction cleanly and MOD gives it back in the smaller unit, so nothing needs rounding.