Thread: precentage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default precentage

See if this helps:

For the below data in Cells A1:B3

$83.90 39%
$131.28 61%
$215.18 100%

A3: =SUM(A1:A2)
B1: =A1/$A$3
B2: =A2/$A$3
B3: =A3/$A$3

format B1:B3 as percents

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"JCornwall" wrote:

If i have a total dollar amount owed monthly of $215.17. But my company pays,
for $131.28 and the remainder is paid by me of $83.90. How do i find out the
total percentage that is paid by my company? In formulars for excel?