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.

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

"JEHU" wrote in message
...
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.

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.


In article ,
JEHU wrote:

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.