Simple Formula Help
 

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
---------
$57, 724 (total)
What % is each value above of the total?

Simple Formula Help
 

Hi Chris

=A1/A4

Carim

Simple Formula Help
 

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.

"Chris" wrote:

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
---------
$57, 724 (total)
What % is each value above of the total?

Simple Formula Help
 

Thanks!


"Carim" wrote:

Hi Chris

=A1/A4

Carim

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.