Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

How to calculate percent sold in Excel

To calculate percentage sold, you can use a simple formula that divides sold amount by the total amount.

Formula

=sold/total


Note: when working manually, percentage results are calculated by dividing one number by another, then multiplying by 100 to express as a percentage. However, because Excel can display decimal or fractional values automatically as a percentage by applying the Percentage number format, there is no need to multiply by 100.

Also See:   Understanding Named Range, Named Constant, Name Manager in Excel Formulas

Explanation

In the example shown, the formula in E6 is

=D6/C6

How this formula works

This formula simply divides the told sold by the total. In cell E6, the formula is solved like this:

=D6/C6
=120/144
=0.83333

When the result is formatted using the Percentage number format .83333 is displayed as 83%.

Also See:   Excel Two-Way Lookup Example

Leave a Reply

Your email address will not be published. Required fields are marked *