Home » Posts

Percent sold

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.

April 14, 2025 · 1 min · 43 words · Tiffany Hammond

As the formula is copied down, the formula returns percentage sold for item in the table.

For example, 45% is read as “Forty-five percent” and is equivalent to 45/100 or 0.45.

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

Excel formula: Get percentage of total

Excel formula: Percent of goal

Excel formula: Get amount with percentage

Excel formula: Get percent of year complete

Excel formula: Get profit margin percentage