#1   Report Post  
Posted to microsoft.public.excel.newusers
JCornwall
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre
 
Posts: n/a
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find precentage result Pat Excel Worksheet Functions 1 March 21st 06 06:12 PM
Find precentage result Pat Excel Worksheet Functions 1 March 21st 06 06:06 PM
how do i use a formula to work a precentage of a percentage Natalie Excel Worksheet Functions 2 May 13th 05 02:11 PM
What is the correct precentage difference Pat Excel Worksheet Functions 8 November 24th 04 10:01 PM


All times are GMT +1. The time now is 01:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"