precentage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top