#### skinnea

##### Board Regular

- Joined
- Mar 15, 2003

- Messages
- 135

- Office Version
- 365

- Platform
- Windows

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