excel formulas

J

JEHU

I need to find out which excel formula or function to use. Here's my
example: If I need to raise $46,000 for a fund-raiser, and I have 4
organizations to do this with, how do I figure out how much money each
organization is responsible for raising? The first oganization consists
1,202 personnel. The second 724, the third 732, and the fourth 36, for a
total of 2,694 personnel. Please note, I am a novice excel user.
 
P

Paul B

JEHU, If each organization has to raise the same thing just divide the 46000
my 4, 11500 each.
If you want to get the "fair share" by number of people 46000/ 2694
=17.07498 times the number of people in each organization so you would get:
first one 20524.13, second one 12362.29, third one 12498.89, fourth one
614.70

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
J

JE McGimpsey

If you assume that each person is to raise an equal amount, one way:

A B C
1 Organization # people Amt to raise
2 Org 1 1202 =B2/B$6*C$6
3 Org 2 724 =B3/B$6*C$6
4 Org 3 732 =B4/B$6*C$6
5 Org 4 36 =B5/B$6*C$6
6 =SUM(B2:B5) 46000

If you enter the formula in B2, you can copy it down to B5.
 
Top