Excel formula: Get amount with percentage

Generic formula

= total*percent

Summary

If you have a total and a percentage that presents some amount of the total, you can calculate the amount represented by the percentage with a simple formula that multiplies the total by the percentage.

Explanation

In the example, E6 cell contains this formula:

=C6*D6

To calculate the amount, Excel simply multiplies the value in cell C6 ($1,120) by the percentage value in cell D6 (.625). The result is $700, which is 62.5% of $1,200.

=1120*.625=$700

Note that the value in cell D6 is a decimal value (in this case .625) formatted with the Percentage number format and zero decimal places. This causes .625 to display as 63%.

Author

Dave Bruns

Related formulas

Get total from percentage

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. Note that the value in cell...

Get percentage of total

In the example, D6 contains the formula below, copied down: = C6 / $C$11 In cell D6, the result of the calculation is .625. The Percentage number format is applied to cell D6, with 2 decimal places, so Excel displays .625 as 63%. The reference to...

Get percentage discount

In the example, the active cell contains this formula: =1-(D5/C5) In this case, Excel first divides the discounted price in D5 (59.5) by the original price in C5 (70) to get 0.85, which is then subtracted from 1: =1-(59.5/70) =1-0.85 =0.15 Note: the...

Increase by percentage

In the example, the active cell contains this formula: = C6 * ( 1 + D6 ) In this case, Excel first calculates the result of 1 + the value in D6 (.2) to get 1.2 which it then multiplies times the value in C6 (70) to get a final result of 84: =70 * (1...

Decrease by percentage

In the example, the active cell contains this formula: = C6 * ( 1 - D6 ) In this case, Excel first calculates the result of 1 - the value in D6 (.2) to get 0.8 which it then multiplies times the value in C6 (70) to get a final result of 56: =70 * (1...

Get original price from percentage discount

In the example, the active cell contains this formula: = C6 / ( 1 - D6 ) In this case, Excel first calculates the result of 1 - the value in D6 (.2) to get 0.8. Next the value in C6 (56), which represents the discounted or "sale" price, is divided...

Cap percentage at specific amount

This formula uses the MIN function to make a decision that might otherwise be handled with the IF function . Although MIN is usually used to return the minimum value in a data set with many numbers, it also works fine for "lesser of the two"...

Summary count with percentage breakdown

COUNTIF is set up to count cells in the named range "category", which refers to B5:B122. The criteria is supplied as a reference to H4, which simply picks up the value in column F. the COUNTA function simply counts all non-blank cells in the named...

Percent of students absent

The formula in F5 first calculates the number of students absent using (C6-D6), then divides the result by the total students. So the formula reduces like this: = ( C6 - D6 ) / C6 = ( 100 - 92 ) / 100 = 8 / 100 = .08 When formatted using the...

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.