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