Simple Formula Help
Chris wrote:
What formula do I use to find the percent of a total amount?
Example
$1124
$55650
$950
---------
$57, 724 (total)
What % is each value above of the total?
=A1/$A$4
=A2/$A$4
=A3/$A$4
Format each cell as Percentage with Decimal Places 2 (click on Format
Cells Number).
Using $A$4 in the denominator facilitates copying the formula.
|