skinnea
Board Regular
- Joined
- Mar 15, 2003
- Messages
- 135
- 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