Summary

To calculate the percentage sold any given item you can use a simple formula that divides sold amount by the total amount. In the example shown, the formula in E6 is

=D6/C6

The results in column E are decimal values with the percentage number format applied.

Generic formula

=sold/total

Explanation 

In this example, the goal is to calculate the percentage sold for each item listed in the table, where original number (Total) is in column C and the Sold number is in column D. In other words, if we know we started with 144 apples, and sold 108 apples, we want to calculate that 75% of the apples were sold. The general formula for this calculation, where "x" is the percentage sold, is:

x=total/sold
x=144/108
x=0.75

Converting this to an Excel formula with cell references, the formula in E5 becomes:

=C5/D5
=144/108
=0.75

When the result the Percentage number format is applied, 0.75 is displayed as 75%. As the formula is copied down, the formula returns percentage sold for item in the table.

Formatting percentages in Excel

In mathematics, a percentage is a number expressed as a fraction of 100. For example, 45% is read as "Forty-five percent" and is equivalent to 45/100 or 0.45. Accordingly, the results in column E are decimal values, with the Percentage number format applied.

Related formulas

Excel formula: Get percentage of total

Get percentage of total

In this example, the goal is to work out the "percent of total" for each expense shown in the worksheet. In other words, given that we know the total is $1945, and we know Rent is $700, we want to determine that Rent is 36% of the total. The total already exists in the named range total (C15) which...
Excel formula: Percent of goal

Percent of goal

In this example, the objective is to calculate a percentage for each goal shown in column C of the table using the actual values in column D. In other words, given a goal of 100000, and an actual amount of 112000, we want to return 112% as the result. The general formula for this calculation, where...
Excel formula: Get amount with percentage

Get amount with percentage

In this example, the goal is to convert the percentages shown in column C to amounts, where the total of all amounts is given as $1945. In other words, if we know Rent is 36.0%, and the total of all expenses is $1945, we want to calculate that Rent is $700. With "x" as the number we want to find,...
Excel formula: Get percent of year complete

Get percent of year complete

The goal in this example is to return the amount of time completed in a year as a percentage value, based on any given date. In other words, when given the date July 1, 2021, the formula should return 50% since we are halfway* through the year. *By default, the YEARFRAC function uses a 30/360 day...
Excel formula: Get profit margin percentage

Get profit margin percentage

In this example, the goal is to calculate and display profit margin as a percentage for each of the items shown in the table. In other words, given a price of $5.00 and a cost of $4.00, we want to return a profit margin of 20%. Each item in the table has different price and cost, so the profit...

Related videos

How to use percentage formatting in Excel

In this lesson we'll look at the Percentage format. The Percentage format is made to display fractional values as percentages. For instance, the value .05, formatted as a percent, will display as 5%. Let's take a look. In column B of our table we have a set of numbers in General format. Let's first...
Dave Bruns Profile Picture

AuthorMicrosoft Most Valuable Professional Award

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Formulas

Videos

Training