tiered bonus

The bonus appears to tiered as follows:

=C1+C2*1.1+C3*1.21 i.e tiers increment by 10%

where C1=Number of employees in Tier1, C2=Number in Tier2, c3=Number in Tier3

Using above we get result of 25.61 (in H1 .. see below)

To allocate bonus:

use

in I1

=ROUNDUP(C1*(1+0.1) ^(ROWS($1:1)-1)/$H$1*$G$1,2)

where h1=25.16
g1=20000

Copy formula down to I3

Thanks, I will try that and update the thread if it works as expected.