Formulasand calculations

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...
 
A

Anne Troy

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]...
 
D

Dana DeLouis

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]...
 
Top