This is a straightforward calculation in Excel.
The main task is to correctly enter the numbers in column D as percentages.
Once that is done, you’re able to multiply the percentage by the number.
The first step is to format the cells in therangeD5:D12 with thepercentage number format.
you’re able to use the keyboard shortcutControl + Shift + %.
Once the cells are correctly formatted, you’re free to enter the numbers without the %operator.
Excel will automatically add the % sign.
Next, enter the formula in cell E5.
This locks the reference and prevents changes as the formula is copied down.
Because the reference to cell D5 isrelative, it will change at each new row.
Note: the percentages in column D are completely arbitrary and can be changed as desired.
