Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to get last column number in range in Excel
  • Convert text string to valid reference in Excel using Indirect function
  • How to use Excel FORMULATEXT function
  • How to get address of last cell in range in Excel

Data Analysis Examples

  • Excel Line Chart
  • How to Use Solver Tool in Excel
  • Reverse List in Excel
  • How To Filter Data in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel

Data Validation Examples

  • Excel Data validation only dates between
  • How To Create Drop-down List in Excel
  • Excel Data validation number multiple 100
  • Excel Data validation don’t exceed total
  • Excel Data validation must not contain

How to calculate percent of goal in Excel

by

If you need to calculate percent of goal, you can do so with a simple formula that divides the actual by the goal amount, with the result formatted using the percentage number format.

This same formula can be used to calculate things like percent of target, percent of budget, percent of forecast, and so on.

Worked Example:   Paste Special Operations in Excel

Formula

=actual/goal

Explanation

In the example, we are calculating percent of Forecast, so we simply need to divide the actual result in column D with the Forecast in column C and format the result in column E as using the Percentage number format.

In cell E5, the formula is:

=D5/C5

How this formula works

When working manually, percentage results are calculated by dividing one number by another (for example, a part by a whole) to get a decimal value, then multiplying by 100 to express as a percentage.

Worked Example:   How to get original price from percentage discount in Excel

Excel can display decimal or fractional values automatically as a percentage by applying the Percentage number format, so there is no need to multiply by 100.

Worked Example:   Subtract Numbers in Excel

Negative goal

If you have a negative goal, the formula above won’t calculate correctly. In this case, you can calculate the variance as explained here, then add the variance to 100% to get the percent of goal:

=(actual-goal)/ABS(goal)+100%

Post navigation

Previous Post:

How to calculate percent of students absent in Excel

Next Post:

How to increase by percentage in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • LOWER function: Description, Usage, Syntax, Examples and Explanation
  • How to extract text between parentheses in Excel
  • How to use double quotes inside a formula in Excel
  • Convert Numbers to Text in Excel
  • Find function vs Search function in Excel
  • Get work hours between dates custom schedule in Excel
  • Series of dates by day
  • Get month name from date in Excel
  • Get day name from date in Excel
  • Get last working day in month in Excel
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
  • YIELD function: Description, Usage, Syntax, Examples and Explanation
  • COUPNUM function: Description, Usage, Syntax, Examples and Explanation
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles