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

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.

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.

Format cell using Percentage in Excel

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

Also Read: Create Named Cells or Named Range in Excel and Use the Names in Formula for Data Validation

That's it. Thanks for reading.

← PreviousNext →


Like this Article? Subscribe now, and get all the latest articles and tips, right in your inbox.
Delivered by FeedBurner