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 how much in dues they should 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=389886