I want to model my new employee add projection. So if the new client list goes above 100, we will add 1 new Account manager "AM" and for every 80 clients will add one new engineer Add employee.xlsxAdd employee.xlsx. I have attached my desired result in the file.
Try
in F11
=IF(MOD(INT(F$8),$C11)=0,1,"")
Copy down and across
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
2 similar formulas.
In E11:
Formula:
Please Login or Register to view this content.
In E12:
Formula:Please Login or Register to view this content.
Drag both across
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
Or other 2:
In E11
Formula:Please Login or Register to view this content.
In E12
Formula:Please Login or Register to view this content.
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Re: How do I add new employee after every 100 new customer we add
with Power Query
Last edited by sandy666; 11-04-2022 at 05:26 PM. Reason: file update
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks