In general, if you want to calculate the percent of goal, you can simply divide the actual to the expectation then percentage the result. In this tutorial, we will go through a sample to calculate the Goal percentage.
Percent Of Goal in Excel
Formula for percent of goal
Explanation of formula
This formula can be applied to find target percentage, budget percentage, percent of forecast, etc.
Calculate percent target of the total sale of fruit.
Applying general formula, to calculate the percent of the goal of Apple, we will input:
Figure 1. Input formula to calculate the percent of target.
Dragging the formula from F5 to F10 to calculate the percent of the goal of all kinds of fruit and also the total.
Figure 2. Change the result format to percentage number format
In manually working, to find the percentage of a number, we will multiply by 100 to express in percentage.
While using excel, we can change the result format to percentage number format by highlight all the number and click on percentage.
Alternative: Comparing the actuals to one common target
Figure 3. Example of a common goal
Note that the $E$3 is ensuring that the cell reference will not move as you copy the formula.
Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free.