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.
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.
In the example shown, the formula in E6 is
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%.