How to calculate total from percentage in Excel

by

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.

Worked Example:   Excel Two-Way Lookup Example

Formula

= amount / percent

Explanation

In the example, the active cell contains this formula:

=C6/D6

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

Worked Example:   How to calculate decrease by percentage in Excel

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

Worked Example:   Transpose: Switch 'Rows to Columns' or 'Columns to Rows' in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *