Simple Formula Help

[Guest]

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

 

[Carim]

Hi Chris

=A1/A4

Carim

 

[Guest]

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.

 

[Guest]

Thanks!

 

[joeu2004]

What formula do I use to find the percent of a total amount?
Example
$1124
$55650
$950

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