View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default 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.