The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Excel Formula Help !!!
Dodo
Registered User new member
Registered User new member
Good day to all,
Can someone help me to find formulas to go in the "BOLD" cell. I need a formula inside those 3 cells that will take the 5 first employees of my total, then the 10 next employees of the total and all the left ones. See example below, pretend that it's in an Excel Sheet.
Population
Employees 7
Employees (Consultants) 22
Employees (Others) 6
Total 35
Fisrt 5 employees (10 m2) 5 = 50.00
Next 10 employees (6 m2) 10 = 60.00
Other employees (4m2) 15 = 60.00
Support total 35 = 170.00
Thanks
Can someone help me to find formulas to go in the "BOLD" cell. I need a formula inside those 3 cells that will take the 5 first employees of my total, then the 10 next employees of the total and all the left ones. See example below, pretend that it's in an Excel Sheet.
Population
Employees 7
Employees (Consultants) 22
Employees (Others) 6
Total 35
Fisrt 5 employees (10 m2) 5 = 50.00
Next 10 employees (6 m2) 10 = 60.00
Other employees (4m2) 15 = 60.00
Support total 35 = 170.00
Thanks
0
This discussion has been closed.