On 16 May 2020 at 21:25, Bill Benson wrote: > What does this mean: " The formula instantly assigns those 3 x ANSWER > NUMBERS above to the relevant tiers ". Is this a single formula that > you think you can put in each Tier? Not possible. Paste =MIN($A2-SUM($B2:B2),C$1-B$1 into one cell and copy to the other tiers. :-)