Exceljet

Quick, clean, and to the point

Percent of goal

Excel formula: Percent of goal
Generic formula 
=actual/goal
Summary 

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.

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
Explanation 

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.

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.

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%
Author 
Dave Bruns
Related formulas 
Excel formula: Get percentage of total
Get percentage of total
In the example, D6 contains the formula below, copied down: = C6 / $C$11 In cell D6, the result of the calculation is .625. The Percentage number format is applied to cell D6, with 2 decimal places, so Excel displays .625 as 63%. The reference to...
Excel formula: Calculate percent variance
Calculate percent variance
The concept of variance requires a baseline value and a "new" value. Once you calculate the difference between the two numbers, you only need to divide by the original value. In the example, we are calculating a variance from forecast, so we need...
Excel formula: Project complete percentage
Project complete percentage
At the core, this formula simply divides tasks complete by the total task count: = complete / total which is then formatted as a percentage. To count complete tasks, we count non-blank cells in the range C5:C11: = COUNTA ( C5:C11 ) To count total...
Excel formula: Percent sold
Percent sold
This formula simply divides the told sold by the total. In cell E6, the formula is solved like this: = D6 / C6 = 120 / 144 = 0.83333 When the result is formatted using the Percentage number format .83333 is displayed as 83%. Note: when working...
Excel formula: Percent of students absent
Percent of students absent
The formula in F5 first calculates the number of students absent using (C6-D6), then divides the result by the total students. So the formula reduces like this: = ( C6 - D6 ) / C6 = ( 100 - 92 ) / 100 = 8 / 100 = .08 When formatted using the...
Excel formula: Get percent of year complete
Get percent of year complete
the YEARFRAC function takes two dates, a start date and and an end date, and calculates the time between them in fractional years. In this case, we are using the end date as-is, but generating a start date that equals the first day of the same year...
Related courses 
Core Formula

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

500 Formulas | 101 Functions

Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.