Formulasand calculations

  • Thread starter Thread starter bill_robinson
  • Start date Start date
B

bill_robinson

Hello everyone- i work for a very small non-profit and need some help
calculating some spreadsheet values. if anyone can help with this
problem, i would really appreciate it. here it goes....

i am putting together a list of busnesses and am trying to calculate a
formula based on the number of employees they have and the
classification of the business.. for example... AAA enterprises has 52
employees and a manager.
i need to calculate what they can pay.. for the manager they pay $200,
next 9 people each at $17, next 10 people each $14, next 30 each $9,
and next 50 people each and over $7. the total for AAA would be $777..
is there a way to set up a formula so i can just put the number of
employees and let the spreadsheet do the work for me???

thanks for your help...
 
Hi, Bill. Are you trying to develop your own estimates and basing it on
these numbers? So if there were 10 people, we'd need to come up with $200
for the manager and $153 for the 9 people at $17, giving a total of $353?
Then if there were 11 people, we'd add $14 for that extra person? I'm not
sure what you mean...
*******************
~Anne Troy

www.OfficeArticles.com



"bill_robinson" <[email protected]>
wrote in message
news:[email protected]...
 
Would this work for you? A1 holds the value of 52. This assumes only 1
manager, and I did not add a test for a zero.

=MIN(183+17*A1,213+14*A1,313+9*A1,413+7*A1)

HTH
--
Dana DeLouis
Win XP & Office 2003


"bill_robinson" <[email protected]>
wrote in message
news:[email protected]...
 
Back
Top