Which formula should I put on a dashboard?

Pick one primary percent and put the other in a tooltip or subtitle. Mixing titles without labels confuses readers.

Why divide by goal instead of progress?

The goal is the full standard. Dividing by progress would answer a different question (how many times you have covered your current pile).

Can remaining be negative?

The raw gap can be negative when progress exceeds goal. For “remaining work” reports, show 0% remaining and explain overage in words or a separate metric.

Is this the same as percentage change?

No. Percentage change compares new and old values. Percent to goal compares progress to a fixed target. See the homepage section on percent to goal vs percentage change.

Do I need both formulas every time?

You need both only if your audience wants both views. One division chain produces both results.

Percent to Goal Formula: Completion & Remaining %

Every percent-to-goal report rests on two formulas: one for how much is done, one for how much is left. Once you know which letter is progress and which is goal, the arithmetic is the same in finance, fitness, and classrooms.

Open the calculator

Quick answer

Completion percentage divides progress by goal. Remaining percentage divides the gap by goal. Both use the goal as the denominator, not the progress.

Formula

Completion % = (Progress ÷ Goal) × 100
Remaining % = ((Goal - Progress) ÷ Goal) × 100
Amount left = Goal - Progress (use max(..., 0) when reporting remaining work only)

Introduction

Formulas look intimidating until you label the cells. Progress is what you have now. Goal is what you are trying to reach. Everything else is division and multiplication by 100.

Students, analysts, and team leads use the same pair of equations. The difference is only which percent they put on the slide title.

This guide writes the formulas in words and symbols, explains current value versus target value, and shows how completion and remaining relate.

Verify any row with the Percent To Goal Calculator or with How to Calculate Percent to Goal.

Current value vs target value

Current value (progress) is the numerator for completion. It counts what has already happened: dollars saved, deals closed, miles run, assignments submitted.

Target value (goal) is the denominator for both completion and remaining. It is the full planned amount for the period. Percent to goal always divides by the goal, never by progress alone.

Completion percentage formula: divide progress by goal, then multiply by 100. A result of 0.75 becomes 75% complete.

Remaining percentage formula: subtract progress from goal to get the gap, divide the gap by goal, then multiply by 100. The same 75% complete scenario implies 25% remaining.

Formula explanation in one sentence: you are asking what fraction of the target is done or undone, then scaling that fraction to a percent.

Formulas side by side

Let P = progress, G = goal (same units, G > 0)
Completion % = (P / G) × 100
Remaining % = ((G - P) / G) × 100
Equivalently: Remaining % = 100% - Completion % (when 0 ≤ P ≤ G)

Use completion when you celebrate achievement. Use remaining when you stress the gap before a deadline.

If progress can exceed goal, decide whether to cap completion at 100% for external reports. Document that choice once and apply it every week.

Spreadsheet users can copy these patterns from Percent to Goal in Excel.

Apply the formula step by step

Write P and G with units. Example: P = $750, G = $1,000. Do not mix dollars with hours in the same fraction.
Compute completion. 750 ÷ 1,000 = 0.75. Multiply by 100 for 75% complete.
Compute the gap. 1,000 - 750 = 250 remaining in raw dollars.
Compute remaining percent. 250 ÷ 1,000 = 0.25. Multiply by 100 for 25% remaining.
Cross-check the sum. 75% + 25% = 100% when progress is between zero and goal.
Round for the audience. Slides may show whole percents; internal sheets may keep two decimals. Stay consistent.

Numeric walkthrough

Suppose P = 30 units and G = 120 units. Completion = 30/120 = 0.25, so 25% complete.

Gap = 120 - 30 = 90 units. Remaining = 90/120 = 0.75, so 75% remaining.

If you reversed the denominator and divided by 30, you would get 400%, which is not a meaningful “percent to goal.”

Enter 30 and 120 in the homepage calculator to confirm 25% completion, 75% remaining, and 90 units left.

Frequently asked questions

Which formula should I put on a dashboard?: Pick one primary percent and put the other in a tooltip or subtitle. Mixing titles without labels confuses readers.
Why divide by goal instead of progress?: The goal is the full standard. Dividing by progress would answer a different question (how many times you have covered your current pile).
Can remaining be negative?: The raw gap can be negative when progress exceeds goal. For “remaining work” reports, show 0% remaining and explain overage in words or a separate metric.
Is this the same as percentage change?: No. Percentage change compares new and old values. Percent to goal compares progress to a fixed target. See the homepage section on percent to goal vs percentage change.
Do I need both formulas every time?: You need both only if your audience wants both views. One division chain produces both results.

Conclusion

The percent to goal formula family is two fractions with the same denominator. Learn them once, then reuse across savings, sales, and study tracking.

Keep P and G labeled, guard against a zero goal, and pair percents with raw gaps when stakes are high.

Practice one hand calculation, then let the calculator handle routine updates.