Quick answer

Manual: divide progress by goal for completion; subtract and divide for remaining. Calculator: enter two fields. Spreadsheet: reference two cells. Shortcut: when goal is 100, progress equals completion percent.

Formula

  • Completion % = (P ÷ G) × 100
  • Remaining % = ((G - P) ÷ G) × 100

Introduction

Different situations call for different tools. A homework problem may require pencil math. A weekly sales huddle may need a live spreadsheet. A quick personal check might only need a phone and the homepage calculator.

This article walks through each method with the same example so you can see that the answers match.

Before any method, confirm that progress and goal use the same unit and that the goal is greater than zero.

If you need vocabulary first, read What Is Percent to Goal?, then return here for procedure.

Before you calculate

Manual calculation builds understanding. You see every division step, which helps when someone asks “where did that percent come from?” in a meeting.

Calculator method trades steps for speed. It fits field checks, parent-teacher updates, and quick fundraising posts.

Spreadsheet calculations scale when you track ten goals across twelve weeks. One formula row copies down the column.

Shortcut methods work when the goal is 100 or when progress is an obvious fraction of goal (half, quarter). They are poor fits when goals are irregular numbers like $6,240.

Pick the method that matches how often you repeat the task, not the method that looks most impressive.

Core math (all methods)

  • Completion % = (P ÷ G) × 100
  • Remaining % = ((G - P) ÷ G) × 100
  • Amount left = G - P

Every method above is just a different interface for these two ratios.

Excel details live in Percent to Goal in Excel.

Four ways to calculate

  1. Manual calculation. Write P and G. Divide P by G for completion decimal; multiply by 100. Subtract P from G, divide by G, multiply by 100 for remaining. Show one example on paper before trusting mental math.
  2. Calculator method. Open calculator on the homepage. Enter current progress in the first field and goal in the second. Read completion %, remaining %, and amount left. No submit button; results update as you type.
  3. Spreadsheet calculations. Put progress in cell A2 and goal in B2. Completion: =A2/B2 formatted as percent. Remaining: =(B2-A2)/B2 formatted as percent. Copy down for multiple rows.
  4. Shortcut when goal is 100. If the goal is 100 points, dollars, or percent scale, progress number equals completion percent. Remaining is 100 minus progress.
  5. Shortcut for easy fractions. If progress is half the goal, completion is 50%. If progress is a quarter of goal, completion is 25%. Still verify when stakes are high.
  6. Document and share. Note the date, P, G, and both percents in your report. Future you will thank present you when someone audits the slide.

Same numbers, four methods

Let P = 18 and G = 24 (units sold, hours studied, or any shared measure).

Manual: 18/24 = 0.75 → 75% complete. Gap = 6, 6/24 = 0.25 → 25% remaining.

Calculator: enter 18 and 24; panels should show 75%, 25%, and 6 left.

Excel: A2=18, B2=24, completion cell =A2/B2, remaining =(B2-A2)/B2.

Shortcut check: 18 is three-quarters of 24, so 75% complete is sensible.