Enter an equal sign and open parenthesis and select the cell. If you have a list of sale orders for each month and you have calculated the total orders for these months now you want to get the percentage of each month based on the total how could you solve this job in Excel. For example enter 1500 into A1.
For example enter 1500 into A1.
Calculate the percentage of total with formula. Get amount with percentage In the example E6 cell contains this formula. C6 D6 To calculate the amount Excel simply multiplies the value in cell C6 1120 by the percentage value in cell D6 625. Calculate a percent distribution you can use a formula that simply divides an amount by the total.