**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

To apply the formula,

• select the cell **D2**

• insert the formula by typing =(c1 / b2) * 100

• press the enter key

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.

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

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

That's it. Thanks for reading. ☺