Home » Posts

Percent of goal

To calculate the percentage of a goal attained, you can use a simple formula that divides the actual by the goal amount, with the result formatted using the percentage number format. In the example shown, the formula in cell E5 is: =D5/C5 The results in column E are decimal values with the percentage number format applied. This same formula can be used to calculate things like percent of target, percent of budget, percent of forecast, and so on.

April 14, 2025 · 1 min · 55 words · Alicia Moore

Table of Contents

When these numbers are formatted with thePercentage number format, they are displayed as percentages.

For example, 25% is read as “Twenty-five percent” and is equivalent to 25/100 or 0.25.

Accordingly, the values in column E aredecimal values, with thePercentage number formatapplied.

Excel formula: Get percentage of total