Formula to Calculate Sales Percentage in Excel

There's a simple division formula that you can use to calculate the sales percentage in Excel. Let us assume you have a list of items and number of items sold in a given period. Now, you want to calculate the sales percentage of the items.

Syntax

Items_sold / total_items

See the image above. I have a list of items (or products), the total quantity and items sold within a given period. The last column shows sales percentage, which tells me the percentage of sales done for each item.

👉 What is the formula to split texts or words from a cell to multiple cells? Using a new function in Excel.
Read this post

The formula

See the percentage column in the image. The formula to calculate the sales percentage is (sold / quantity) * 100. That is, it will first divide the value and later multiply by 100.

To apply the formula,

• select the cell D2
• insert the formula by typing =(c1 / b2) * 100
• press the enter key

You may also like: Excel formula to get Half-Yearly, Quarterly and Yearly date from a given Date

Don’t have to write the formula again for other products. Simply, select cell D2, hover the mouse over the cell, you will see a little + sign, hold it and drag it down. See the image.

To round of the percentage result, you can use the ROUND() function.

You can further simplify the above formula. Don’t multiply the result with 100. Simply, format the cell(s) as Percentage. See the image.

Here's another commonly used formula: The formula to Calculate Percentage (%) Change in Excel

No need to round of the result and in-addition, it automatically adds the % symbol to the result.

That's it. 🙂

Also read... What is the formula to "multiply" two alpha-numeric cell values in Excel?

← PreviousNext →