skinnea
Board Regular
 Joined
 Mar 15, 2003
 Messages
 128
 Office Version

 365
 Platform

 Windows
I have a set of NUMBERS, and each NUMBER in that set can be any positive integer.
I want to split each NUMBER across 3 TYPES (A, B, and C).
There can be any QUANTITY of each of the 3 TYPES (from 0 to positive integer n)
Sometimes the QUANTITY of TYPE C and/or TYPE B is greater than the QUANTITY of TYPE A
Regardless of the total QUANTITY of TYPES A, B, and C in total, is there a formula that will split each NUMBER across the 3 TYPES in such a way that;
• Each QUANTITY of each TYPE has the same ‘share’ of the overall NUMBER
• 1 QUANTITY of TYPE A is always greater than 1 QUANTITY of TYPE B, which in turn is always greater than 1 QUANTITY of TYPE C
For example;
there are 3 QUANTITIES of TYPE A, all equal to 100
there are 2 QUANTITIES of TYPE B, all equal to 75
there are 5 QUANTITIES of TYPE C, all equal to 50
Where the NUMBER as a whole was 700.
It's driving me and my team up the wall, we just can't figure this one out
I want to split each NUMBER across 3 TYPES (A, B, and C).
There can be any QUANTITY of each of the 3 TYPES (from 0 to positive integer n)
Sometimes the QUANTITY of TYPE C and/or TYPE B is greater than the QUANTITY of TYPE A
Regardless of the total QUANTITY of TYPES A, B, and C in total, is there a formula that will split each NUMBER across the 3 TYPES in such a way that;
• Each QUANTITY of each TYPE has the same ‘share’ of the overall NUMBER
• 1 QUANTITY of TYPE A is always greater than 1 QUANTITY of TYPE B, which in turn is always greater than 1 QUANTITY of TYPE C
For example;
there are 3 QUANTITIES of TYPE A, all equal to 100
there are 2 QUANTITIES of TYPE B, all equal to 75
there are 5 QUANTITIES of TYPE C, all equal to 50
Where the NUMBER as a whole was 700.
It's driving me and my team up the wall, we just can't figure this one out