Simple Formula Help

C

Chris

This seems simple enough but I can't get it right. What formula do I use to
find the percent of a total amount?

Example
$1124
$55650
$950
 
M

Miguel Zapico

Supposing your data is in cells A1:A3, and the total in A4, you can enter a
formula like this on cell B1:
=A1/$A$4
Format the cell as percentaje and copy it to cells B2 and B3.

Hope this helps,
Miguel.
 
J

joeu2004

Chris said:
What formula do I use to find the percent of a total amount?
Example
$1124
$55650
$950
Click to expand...

=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.
 
Top