precentage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JCornwall - 17 May 2006 21:32 GMT

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?

Reply to this Message

Ron Coderre - 17 May 2006 21:51 GMT

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

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

Reply to this Message