"Take 15% off" sounds simple until the receipt shows a subtotal, a tax line, and a service fee. Percent of a number is not hard arithmetic—it is choosing the right base. Get the base wrong and every downstream comparison is politely wrong.
Discounts: percent of price, not percent of total paid
A jacket tagged $120 with an extra 20% off coupon uses $120 as the base unless the fine print says "after other discounts." Twenty percent of 120 is 24, so $96 before tax. If you accidentally take 20% off an already-reduced $96, you stole $4.80 from the store or from your margin—depending which side of the counter you stand.
Stacked promos need an order: apply employee discount first or coupon first exactly as the policy states. Write the base on each line: "20% × 120 = 24."
Grades: points earned vs points possible
Score 42 out of 50 on a quiz. The percent of the possible points is 42/50 = 84%. If the syllabus later drops the lowest quiz (a different question about weighting), do not multiply 84% by another percent without rereading the rules. Weighted categories mean each category has its own base: exams out of 400, labs out of 100, etc.
When a student asks "what score do I need on the final," solve for the unknown base contribution instead of guessing with an average of percentages.
Budget slices: percent of planned, not actual yet
Marketing gets 12% of a $240,000 annual plan. The slice is $28,800 regardless of whether Q1 underspent. Tracking "12% of actual spend to date" answers a different question and will starve the team in slow months.
Use a Percent of a Number Calculator after you underline the base in the spreadsheet cell comment. If the base changes mid-year because finance reforecast, update the base cell—not the percent.
Quick mental checks
10% is divide by ten; 1% is divide by a hundred. Build from those: 15% = 10% + half of 10%. If a number should be near $30,000 but your sheet shows $300,000, you probably applied percent to a total that already included tax.
Tax lines and running totals
Sales tax is a percent of a subtotal base, not of the post-discount total, in many jurisdictions—read the receipt logic before you model promotions. A "20% off plus 8% tax" promotion sheet should show: discount percent of pretax subtotal, then tax percent of the discounted taxable base.
Running totals in spreadsheets tempt you to take percent of the cumulative column. That answers "what fraction of everything so far," not "what is 15% of this line." Lock line-level bases in a separate column copy-pasted as values before the percent column.
Payroll and commission bases
Commission at 8% is eight percent of what you define as eligible revenue—usually net of tax and returns, not gross headline sales. Payroll mistakes come from applying the percent to the wrong column after someone inserts a subtotal. Highlight the eligible column in green in the sheet template so imports do not shift it.
Tip pools and shared service charges split by headcount are percent-of problems too: the base is the pool dollars, not each server's personal sales, unless policy says otherwise. Write the policy line you are implementing next to the formula cell.
Grants and cap tables use the same grammar
An option pool of 10% is ten percent of fully diluted shares before the grant, or after, depending on the term sheet sentence. Founders who treat "10%" as interchangeable across drafts give away different companies. Circle the defined base in the legal PDF before you model scenarios in a spreadsheet.
Nonprofit grant caps—"no more than 15% admin on this award"—apply to the award amount, not the whole organizational budget unless the grant says so. Auditors look for the base definition; give it to them in the cover memo.
Frequently Asked Questions
Is the "of" number always the bigger one?
No. You can take 200% of a baseline forecast when modeling stretch goals. The base is what the sentence names, not the larger operand.
How do tips fit in?
Tip on the pre-tax subtotal if that is your policy; tip on the post-tax total if local custom does. Pick one base and label it on the split receipt photo.
What about "percent off already reduced"?
Read the sequence. Additional percent off the sale price uses the sale price as base, not the original tag.
Can I add percents directly?
Only when they apply to the same base. Ten percent plus fifteen percent of the same $200 base is 25% of $200, but ten percent off then fifteen percent off is not twenty-five percent off total.
How do I document percent in a report?
Show base, rate, and result: "12% × $240,000 plan = $28,800." Reviewers can audit without reverse-engineering your formula bar.
For comparing two periods after you know each slice, pair this with Percent Change Calculator—change math uses different bases than "percent of."