Get total from percentage

An excel formula to get total from percentage

 Get total from percentage
= amount / percent

If you have an amount and the percentage that the amount represents of a total, you can calculate the total with a formula that simply divides the amount by the percentage.

How the formula works

In the example, the active cell contains this formula:


Excel simply divides the value in cell C6 by the percentage value in cell D6. The result is the number $1,075,95, which is the total of all expenses in this case.

Note that the value in cell D6 is a decimal value (in this case .79).

0 votes. 0 / 5