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, WinXPquot;JCornwallquot; wrote:
gt; If i have a total dollar amount owed monthly of $215.17. But my company pays,
gt; for $131.28 and the remainder is paid by me of $83.90. How do i find out the
gt; total percentage that is paid by my company? In formulars for excel?
- May 16 Wed 2007 20:37
precentage
close
全站熱搜
留言列表
發表留言