Add 1 employee after every 100 client

[ruchperformive]

How can I add new Account manager after every 100 New client/New logo sale and add Engineer after every 80 New client/New logo sale.

Customer Count	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug
Booked Revenue	36,299	58,039	40,913	48,523	51,007	52,337	50,968	50,938
ARPU	4,000	5000​	5000​	5000​	5000​	5000​	5000​	5000​
New Logo	30​	12	10​	10​	10​	10​	10​	10​
Accumulated New Logo	42​	52​	62​	72​	82​	92​	102​
Additional Account manager after every 100 New long sale	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	False​	1​	False​
Additional Engineer after every 80 New long sale	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	1​	FALSE​	False​

 

[BSALV]

it's not 100% obvious what you want, a trial.

size.xlsb
	A	B	C	D	E	F	G	H	I	J	K
1	Customer Count	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug
2	Booked Revenue	36,299	58,039	40,913	48,523	51,007	52,337	50,968	50,938
3	ARPU	4	5000	5000	5000	5000	5000	5000	5000
4	New Logo	30	12	10	10	10	10	10	10
5	Accumulated New Logo	42	52	62	72	82	92	102	102	102
6
7	Additional Account manager after every 100 New long sale		0	0	0	0	0	1	0		100
8	Additional Engineer after every 80 New long sale		0	0	0	1	0	0	0		80
Blad5

Cell Formulas
Range	Formula
B5:J5	B5	=SUM($B$4:C4)
C7:I8	C7	=TRUNC(C$5/$K7)-TRUNC(B$5/$K7)

 

[ruchperformive]

it's not 100% obvious what you want, a trial.

size.xlsb
	A	B	C	D	E	F	G	H	I	J	K
1	Customer Count	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug
2	Booked Revenue	36,299	58,039	40,913	48,523	51,007	52,337	50,968	50,938
3	ARPU	4	5000	5000	5000	5000	5000	5000	5000
4	New Logo	30	12	10	10	10	10	10	10
5	Accumulated New Logo	42	52	62	72	82	92	102	102	102
6
7	Additional Account manager after every 100 New long sale		0	0	0	0	0	1	0		100
8	Additional Engineer after every 80 New long sale		0	0	0	1	0	0	0		80
Blad5

Cell Formulas
Range	Formula
B5:J5	B5	=SUM($B$4:C4)
C7:I8	C7	=TRUNC(C$5/$K7)-TRUNC(B$5/$K7)

Worked like a charm! Thank you