Find Percentage Per Product
In Excel, you can find the percentage of the total amount received from an order by using the following formula:= (Total amount received / Total amount of the order) * 100%
Assuming that the total amount received is in cell C4 and the total amount of the order is in cell C11, you can enter the formula in cell D4 as mentioned in the example below.
Please follow the steps given below and in the image:
EXAMPLE 1 :
Select a blank cell where you want to display the result.
Right Click and Go to Format Cells and select Percentage
Now The Cell will display the result in percentage after formula is applied.
FORMULA as per this example : =$C4/$C$11
Dollar sign in the formula is to fixed the cell ranges.
Once the formula is applied to the cell please hover to the bottom ...