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

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.

That's it. 🙂