Get amount with percentage
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.
How the formula works
In the example, E6 cell contains this formula:
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.
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%.