• Foundation
  • About 13 min
  • 5 practice questions

Finding missing values in tables

Rebuild missing entries in a table from totals, averages, percentages and ratios given in the question, and check the result.

If something looks wrong, please tell us.

Some DI tables have blanks. The question gives a total, an average, a percentage or a ratio, and you must find the missing figure before answering anything else. This is working backwards, and it is a common 'twist' in exam sets. The method is simple: turn every statement into an equation with one unknown.

The toolkit

  • Total known: missing value = total - sum of the known values.
  • Average known: total = average × number of items, then subtract the known values.
  • Percentage known: if x% of the total equals a given amount, total = amount ÷ x × 100.
  • Ratio known: if A : B = m : n and A is known, B = A × n ÷ m.

Worked example 1: totals and a comparison

Four plants P, Q, R, S made a total of 560 (thousand units). P made 120 and R made 150. Q made 20% more than P. Find S.

Output (thousand units)
PlantPQRSTotal
Output120?150?560

Q = 120 × 1.20 = 144. Then S = 560 - (120 + 144 + 150) = 560 - 414 = 146. Check: 120 + 144 + 150 + 146 = 560.

Worked example 2: a percentage gives the total

A family's monthly budget is shown as percentages: Rent 35%, Food 25%, Education 15%, Others 10% and Savings (not given). Rent is ₹16,800. Find the savings in rupees.

The percentages shown add up to 35 + 25 + 15 + 10 = 85, so Savings = 100 - 85 = 15%. Total budget = 16,800 ÷ 35 × 100 = ₹48,000. Savings = 15% of 48,000 = ₹7,200. Always find the missing percentage first, then the total.

Worked example 3: an average gives a total

The average sale of five days is ₹42 (thousand). Four days were 38, 45, 40 and 50. Find the fifth day. Total of five days = 5 × 42 = 210. Total of four days = 38 + 45 + 40 + 50 = 173. Fifth day = 210 - 173 = 37.

A routine for blank-cell questions

  • Write down every figure the question gives, including those in the question text.
  • Decide which statement has exactly one unknown, and solve that first.
  • Feed the answer into the next statement.
  • Check by adding the row or column again, or by recalculating the percentage.

Be careful with phrases such as '20% more than P'. The base is P, so the factor is 1.20. '20% less than P' would use 0.80.

Sometimes one missing value depends on another. Suppose a row total is 300, two cells are unknown but one is twice the other, and the known cells add up to 90. Let the smaller unknown be x. Then x + 2x = 300 - 90 = 210, so 3x = 210 and x = 70. The two cells are 70 and 140, and 70 + 140 + 90 = 300 confirms it. Writing the unknown as x and building one equation is safer than guessing.

Turn every sentence into one equation with one unknown, and solve them in order of difficulty.

— Rule to remember

Key takeaways

  • Missing value = total - the known parts.
  • Total from an average = average × count.
  • Total from a percentage = amount ÷ percentage × 100.
  • Always check by adding back.

Check your understanding

  1. 1. The average of six numbers is 15. Five of them add up to 80. What is the sixth number?

    1. 5
    2. 15
    3. 20
    4. 10
    Show answer

    Answer: D. Total of six = 6 × 15 = 90. Sixth = 90 - 80 = 10.

  2. 2. Education is 18% of a budget and costs ₹1,260. What is the total budget?

    1. ₹6,300
    2. ₹7,000
    3. ₹7,560
    4. ₹22,680
    Show answer

    Answer: B. Total = 1,260 ÷ 18 × 100 = ₹7,000. Check: 18% of 7,000 = 1,260.

  3. 3. Two shops sell in the ratio 3 : 5. The first sold 45 units. How many did the second sell?

    1. 27
    2. 75
    3. 60
    4. 90
    Show answer

    Answer: B. Each part = 45 ÷ 3 = 15. Second = 5 × 15 = 75.

  4. 4. A row of four numbers adds up to 200. Three of them are 45, 60 and 38. What is the fourth?

    1. 53
    2. 67
    3. 93
    4. 57
    Show answer

    Answer: D. Known sum = 45 + 60 + 38 = 143. Fourth = 200 - 143 = 57.

  5. 5. A company's sales in 2022 were 12% more than in 2021. The 2022 sales were ₹2,240 lakh. What were the 2021 sales?

    1. ₹2,000 lakh
    2. ₹1,971.2 lakh
    3. ₹2,008 lakh
    4. ₹2,508.8 lakh
    Show answer

    Answer: A. 2021 sales = 2,240 ÷ 1.12 = 2,000. Check: 2,000 × 1.12 = 2,240.

Privacy · Terms · Refunds · Delivery