Formula to Calculate Sales Percentage in Excel

← PrevNext →

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.

Calculate Sales Percentage in Excel


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

Formula to calculate Sales Percentage in Excel

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.

Calculate Sales Percentage in Excel

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

Using the ROUND() function in Excel

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

Format cell using Percentage in Excel

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

👉 Do you know the formula to Multiply two alphanumeric cell values in Excel? Its simple. See this example.
Formula to multiple two alphanueric cell values in Excel

That's it. Thanks for reading.

← PreviousNext →