New: Boardroom MCP Engine!

Ready to put this into action?

Get the complete AI Integration Playbook β€” Practical AI implementation guide β€” prompt engineering, workflow automation, and ROI frameworks.

Article 027 Β· Part 3

Use AI for Numbers Without Trusting Mental Arithmetic

Make the calculation visible enough for someone else to reproduce it.

By Randy Salars Β· Published

On this page
  1. Separate the question from the arithmetic
  2. Repair a fictional budget
  3. Keep units attached to the numbers
  4. Build an inspectable spreadsheet
  5. Reconcile the correction
  6. Test a few boundaries
  7. Understand percentages before applying them
  8. Do not hide uncertainty with decimal places
  9. Students: show the relationship, not just the answer
  10. Your exercise

Make the calculation visible enough for someone else to reproduce it.

The budget looks finished. Every expense has a row, the total is bold, and the assistant says the plan fits your limit.

Then you add the rows yourself. The total is wrong.

Even a correct sum would not settle everything. The rental may be priced per day while the budget covers a weekend. A required delivery charge may be missing. A percentage may use the wrong starting value.

AI can help frame a calculation, explain formulas, and inspect a spreadsheet. The answer becomes dependable when the inputs, units, formulas, and checks are visible.

Separate the question from the arithmetic

Begin by asking what must be calculated. β€œCan we afford this?” may require an expense total, available funds, timing, and a definition of what the budget includes.

For a simple event budget, write:

Calculate the total required cost from these records. Show each quantity, unit, rate, and formula. Flag missing inputs. Use a calculator or spreadsheet if available, and tell me how to reproduce the result.

If the assistant has actually run a calculation tool, it should identify the calculation or output. If it merely writes an equation in prose, you still need to evaluate it.

A calculator can verify multiplication. It cannot tell you that the rental lasts two days if you entered only one.

Repair a fictional budget

Here are the complete source facts for this exercise. All quoted amounts are final charges for the stated items; no additional taxes or fees are assumed beyond the listed delivery charge.

  • Twelve tables are needed for two billable days at $8 per table per day.
  • Forty activity kits cost $3.25 each.
  • Each of 40 printed packets has six pages, charged at $0.10 per page.
  • The room charge is $120 for the event.
  • Required delivery costs $18 for the order.

The deliberately flawed draft is:

ItemDraft cost
Tables$96
Kits$130
Printing$24
Room$120
Claimed total$350

Find the errors before reading the correction. There is a wrong total, a unit problem, and an omitted required cost.

Keep units attached to the numbers

The rental rate is not simply β€œ$8.” It is $8 per table per day.

Multiply 12 tables by two days to obtain 24 table-days. Then multiply by $8 per table-day to obtain $192. The draft's $96 accounts for only one day.

Printing requires a similar conversion: 40 packets Γ— six pages per packet = 240 pages. At $0.10 per page, the cost is $24.

The units explain why the multiplications make sense. Without them, an assistant might multiply 40 by $0.10 and price each packet as though it were one page.

Write units in source notes and column headings. A decimal such as 0.10 may mean ten cents, ten percent, or one-tenth of an hour depending on the field.

Build an inspectable spreadsheet

You can reproduce the corrected budget in a blank spreadsheet. Put these values into the indicated rows; the labels describe the columns.

RowA: Item and billing unitB: Billable quantityC: Dollars per unitD: FormulaExpected dollars
2Table-days248.00=B2*C2192.00
3Kits403.25=B3*C3130.00
4Printed pages2400.10=B4*C424.00
5Room booking charge1120.00=B5*C5120.00
6Delivery charge118.00=B6*C618.00
7Total=SUM(D2:D6)484.00

The expected-values column is an answer key, not an extra input column you need to create. Enter formulas into D and format the calculated amounts as currency. Microsoft's documentation explains that SUM adds supplied values or ranges. Microsoft: SUM function.

Keep the original quantities too: twelve tables, two days, forty packets, six pages per packet. Otherwise, someone checking the sheet may not know where 24 table-days or 240 pages came from.

Reconcile the correction

The four amounts shown in the flawed draft add to $370, not $350. Correcting the rental adds $96, and adding delivery adds $18. Therefore, $370 + $96 + $18 = $484.

This second route reproduces the corrected total. It also explains the difference rather than merely replacing the number.

An independent check should vary something meaningful: use a calculator, sum the expense groups separately, or ask another person to reproduce the formula from the original records. Asking the same assistant to repeat its conclusion is a weaker check.

Test a few boundaries

What happens if attendance is zero? Kits and printed pages may fall to zero, but the room and rental charges might remain if commitments already exist. The source terms decide.

What if the delivery price is blank? Do not treat blank as free. Mark the budget incomplete or show a subtotal excluding the unknown, clearly labeled.

What if attendance rises to 50? If the event still uses twelve tables for two days, the room and delivery charges stay as supplied while kits and printing change. If more tables are needed, that assumption must change too.

Boundary checks reveal errors in the model of the task, not just arithmetic mistakes.

Understand percentages before applying them

If a cost rises from $80 to $100, the increase is $20 divided by the original $80, or 25 percent. A later fall from $100 to $80 is a 20 percent decrease because the starting value is now $100.

Two increases of 10 percent do not equal a single increase of 20 percent. Starting from $100, the sequence is $110 and then $121, a 21 percent overall increase.

Percentage points are different again: a rate moving from 20 to 25 percent changes by five percentage points, or 25 percent relative to the original rate.

Ask the assistant to state the denominator before calculating. Many errors become obvious as soon as β€œpercent of what?” has an answer.

Do not hide uncertainty with decimal places

A calculation can produce $484.00 exactly from the fictional charges while a real budget still contains uncertain quantities or quotes. Precision in the arithmetic does not remove uncertainty in the inputs.

Record which values are confirmed, estimated, or assumed. Keep full precision during the calculation when needed, then apply an appropriate rounding rule for the final result.

If a vendor rounds each line separately, that may differ from rounding only the final sum. Check the applicable method instead of assuming a discrepancy must be fraud or a software error.

Students: show the relationship, not just the answer

For permitted math or science assistance, ask the assistant to identify quantities and units, then attempt the calculation yourself.

Help me set up this problem without solving it yet. Name the quantities and show the relationship I should use. After my attempt, check the units and locate the first error.

For lab work, preserve actual measurements. Do not replace a messy observation with a cleaner invented value. A spreadsheet is useful because formulas can be inspected, but it still needs correct data and a suitable method.

Your exercise

Recreate the budget and independently reproduce $484. Then change the number of kits and packets from 40 to 50 while keeping the other supplied requirements fixed. The new total should be $522.50.

Finally, remove the delivery price. Produce a clearly labeled subtotal of the known expenses and a note that the required delivery cost remains unresolved.

Completion check: You can reproduce the result from the original inputs, explain every unit, and distinguish a complete total from a subtotal with missing costs.

Get the AI Dispatch

Weekly insights on ai & technology β€” delivered to your inbox. No spam, unsubscribe any time.

Want to choose specific topics? Customize your interests