FormulaCraft

How to calculate the percentage of target achieved in Excel and Google Sheets

Topic:Percentages
Excel & Google Sheets
=B2/C2
✓

Verified example

Computed by a real spreadsheet engine on the sample data below.

RepActualTarget% Achieved
Alice85000100000
Bob110000100000
Carol72000100000
Dave95000100000

=B2/C2→0.85

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

Step by step

  1. 1Set up columns: Name/Product, Actual, Target, % of Target.
  2. 2In D2, enter =B2/C2.
  3. 3Format column D as Percentage.
  4. 4Copy the formula down for all rows. Values above 100% indicate the target was exceeded.

Tips

Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.

Frequently asked

What if actual exceeds target — will the formula still work?

Yes, a result greater than 1 (or 100% when formatted) simply means the target was exceeded.

How do I calculate the percentage gap remaining?

Use =1-(B2/C2) or equivalently =(C2-B2)/C2 to see how much of the target is still outstanding.

More on Percentages

See all →
How-to

How to calculate a percentage

Work out what percentage one number is of another with a simple division, then format the result as a percent. Same in Excel and Google Sheets.

Error fix

Fix Wrong %

Fix wrong percentage results in Excel and Google Sheets — caused by conflating the percentage symbol with the decimal value or double-applying the % format.

How-to

How to calculate percentage change

Find the percentage increase or decrease between two numbers with (new − old) / old, then format as a percent. Works in Excel and Sheets.

How-to

How to add a percentage to a number

Increase a number by a percentage with number × (1 + rate) — handy for tax, markup, or raises. Same in both apps.

How-to

How to calculate a cumulative percentage

Use a running SUM divided by the total SUM to build a cumulative percentage column in Excel or Google Sheets.

How-to

How to calculate attendance percentage

Divide attended sessions by total sessions and multiply by 100 to get attendance percentage in Excel or Google Sheets.

Formulas used

IFERRORSUMAVERAGEPERCENTRANKTRIMMEANIFNALETMAP

Related tasks

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: