< Go Back

Percent sold

Every now and then, we have to perform certain operations on our data. Such operations can be easily performed in Excel by making use of simple formulas. For example, if we have to calculate the percentage sold in some articles, then we can do it by creating a simple formula in Excel.

In a mathematical expression, a sold percentage is found by dividing the sold value by total value and multiplying the result by 100. This expression can be converted to an Excel formula by dividing the cell address containing sold items with the cell address containing total items.

In the above method, when we divide 2 quantities, a decimal number is returned, but we are looking for value in percentage. This can be easily attained by formatting cell.

Formatting cells in excel

Formatting cells refer to changing the appearance or format of the cell quantity/value without changing the value itself. For example, we can format the font, alignment, and change the type of numeric value (percentage, date, currency, general, decimal, etc).

The formula for percentage sold

In general, percentage sold

=sold/total

We can convert this into a formula with cell addresses.

Example

In the example, we are calculating the percentage sold by dividing sold stationary with total stationery. In cell E6, we apply the formula as shown  

=D6/C6

=567/1178

=0.481324278

Figure 1: Illustration of sold percentage formula

Similarly, in F7 the same formula is applied along with changing the format of a cell.

On formatting the cell by making use of the Percentage number format, 0.481324278 is displayed as 48.13%. Similarly, you can apply the above formula to a hefty amount of data by dragging it, so that the result for other inputs can also be obtained.

Figure 2: Result of applying a formula to find the sold percentage

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar