ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   precentage (https://www.excelbanter.com/new-users-excel/89202-precentage.html)

JCornwall

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

Ron Coderre

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?



All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com