Choose function

[dhanesh_kashyap]

Dear Members,

I want to use choose or any other excel function in the following table to distribute 10 K among four members whose priority may change:

[TABLE="width: 432"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Priority[/TD]
[TD="bgcolor: transparent"] 1 [/TD]
[TD="bgcolor: transparent"] 2 [/TD]
[TD="bgcolor: transparent"] 3 [/TD]
[TD="bgcolor: transparent"] 4 [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: #B8CCE4"] Ram [/TD]
[TD="bgcolor: #B8CCE4"] Shyam [/TD]
[TD="bgcolor: #B8CCE4"] Mohan [/TD]
[TD="bgcolor: #B8CCE4"] Taj [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: #B8CCE4"] Funds Available [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: #B8CCE4"][/TD]
[TD="bgcolor: #B8CCE4"][/TD]
[TD="bgcolor: #B8CCE4"][/TD]
[TD="bgcolor: #B8CCE4"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]10000[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]
I am unable to fix this problem. Therefore, please help me and suggest a suitable excel formula to fix it.

Thanks & Regards

Dhanesh

 

[dispelthemyth]

How do you want to split it amongst the 4 people? (i.e. how are you wanting to take the priority into account?)

 

[raj2206]

Hi,

Could you please define the math behind the distribution/priority level?

Thanks/Raj

 

[dhanesh_kashyap]

How do you want to split it amongst the 4 people? (i.e. how are you wanting to take the priority into account?)

Dear Sir,

It can be made in various proportion depending upon the situation . It might be distributed as under :

a) In between two persons equally;
b) to only one person;

R'gds

Dhanesh

 

[dispelthemyth]

Any you will do this how?

Is it always going to be done using a %, is this going to be going into a specific cell, e.g. where you have priority 1,2,3 & 4, will that change to the split %?

Dear Sir,

It can be made in various proportion depending upon the situation . It might be distributed as under :

a) In between two persons equally;
b) to only one person;

R'gds

Dhanesh

 

[dhanesh_kashyap]

Dear Sir,

As I already stated that the ration among these parties may change, which results in having a number of combination wherein part payment would have been done to these people. The ratio which is also changeable.

R'gds

Dhanesh

 

[dispelthemyth]

So what i get from you so far

What You have provided
You want to split £x amongst 4 people
The split ratio of payment is changeable


What YOU are missing
How do YOU want to split the payment amongst the 4 people, you need to give some valid way of splitting it, we don't know your business or how you pay people
You need to provide some logic on how this will be done

Dear Sir,

As I already stated that the ration among these parties may change, which results in having a number of combination wherein part payment would have been done to these people. The ratio which is also changeable.

R'gds

Dhanesh