Formulasand calculations

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

[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]...
>
> 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...
>
>
> --
> bill_robinson
> ------------------------------------------------------------------------
> bill_robinson's Profile:
http://www.excelforum.com/member.php...o&userid=25397
> View this thread: http://www.excelforum.com/showthread...hreadid=388696
>

[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]...
>
> 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...
>
>
> --
> bill_robinson
> ------------------------------------------------------------------------
> bill_robinson's Profile:
> http://www.excelforum.com/member.php...o&userid=25397
> View this thread: http://www.excelforum.com/showthread...hreadid=388696
>

[bill_robinson]

anne- that is excatly what i mean... do you know how to do this?