Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Problem
Im trying to write a formula that will tell me when to add a new employee
based upon the total number of firms or accounts added. If total firms are by month in row 2 and total accounts are in row 3, I want to add a new employee to the employee count in row 4 every time the total firms increases by 10 or total accounts increases by 5000 since the last headcount addition. Any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Problem
Why worry about what happened yesterday, or last month? Instead, how about
simply calculating the maximum number of employees you need in any given month based on the number of Firms/Accounts recorded for the month? January in column B, Firms in row 2, Accounts in row 3, this formula in B4: =MAX(INT((B2/10)+1),INT((B3/5000)+1)) It selects the larger of B2/10 (# firms/10) or B3/5000 (# accounts/5000). The Int()+1 guarantees you'll always have a job (minimum of 1 person). Will that do you any good? (If this is double-post, please excuse the inability of the site to cope with itself -JLL) "gwolfe" wrote: Im trying to write a formula that will tell me when to add a new employee based upon the total number of firms or accounts added. If total firms are by month in row 2 and total accounts are in row 3, I want to add a new employee to the employee count in row 4 every time the total firms increases by 10 or total accounts increases by 5000 since the last headcount addition. Any ideas? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Problem
Thanks for the assist. The formula looks like it will solve the problem.
"JLatham" wrote: Why worry about what happened yesterday, or last month? Instead, how about simply calculating the maximum number of employees you need in any given month based on the number of Firms/Accounts recorded for the month? January in column B, Firms in row 2, Accounts in row 3, this formula in B4: =MAX(INT((B2/10)+1),INT((B3/5000)+1)) It selects the larger of B2/10 (# firms/10) or B3/5000 (# accounts/5000). The Int()+1 guarantees you'll always have a job (minimum of 1 person). Will that do you any good? (If this is double-post, please excuse the inability of the site to cope with itself -JLL) "gwolfe" wrote: Im trying to write a formula that will tell me when to add a new employee based upon the total number of firms or accounts added. If total firms are by month in row 2 and total accounts are in row 3, I want to add a new employee to the employee count in row 4 every time the total firms increases by 10 or total accounts increases by 5000 since the last headcount addition. Any ideas? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Problem
Glad I was able to help some, and thanks very much for the feedback.
"JLatham" wrote: Why worry about what happened yesterday, or last month? Instead, how about simply calculating the maximum number of employees you need in any given month based on the number of Firms/Accounts recorded for the month? January in column B, Firms in row 2, Accounts in row 3, this formula in B4: =MAX(INT((B2/10)+1),INT((B3/5000)+1)) It selects the larger of B2/10 (# firms/10) or B3/5000 (# accounts/5000). The Int()+1 guarantees you'll always have a job (minimum of 1 person). Will that do you any good? (If this is double-post, please excuse the inability of the site to cope with itself -JLL) "gwolfe" wrote: Im trying to write a formula that will tell me when to add a new employee based upon the total number of firms or accounts added. If total firms are by month in row 2 and total accounts are in row 3, I want to add a new employee to the employee count in row 4 every time the total firms increases by 10 or total accounts increases by 5000 since the last headcount addition. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula problem | Excel Discussion (Misc queries) | |||
formula problem | Excel Worksheet Functions | |||
Formula Problem | Excel Discussion (Misc queries) |