close

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?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()