Get percentage of total

To calculate the percent of a total (i.e. calculate a percent distribution), you can use a formula that simply divides a given amount by the total. In the example shown, the formula in D6 is: =C6/total where total is the named range C15. Note: the result is formatted with Percentage number format to show 36%, 18%, etc.

April 14, 2025 · 1 min · 53 words · Ronald Leonard

Table of Contents

For example, 85% is read as “Eighty-five percent” and is equivalent to 85/100 or 0.85.

The formula in D6, copied down, is:

using the named rangetotal(C15).

Formatting percentages in Excel

The numbers in column D are decimal values that express a ratio.

Excel formula: Percent of goal

In cell D6, the ratio is 700/1945, which is approximately 0.36.

Excel formula: Get total from percentage

Excel formula: Get percent change

Excel formula: Increase by percentage

Excel formula: Decrease by percentage

Excel formula: Get amount with percentage

Excel formula: Get percentage discount

Excel formula: Project complete percentage

Excel formula: Get original price from percentage discount

Excel formula: Cap percentage at specific amount

Excel formula: Summary count with percentage breakdown

Excel formula: Get percent of year complete

Excel formula: Get profit margin percentage