This is the perfect time to use a vlookup. Create a charge amount table for
complaints on sheet2. Column A: Number of complaints, Column B: Price.
Select the table and give it a name: prices
Then you can use vlookup: =vlookup(B2,prices,2,false)
If you do it this way, you can change your prices without changing all your
formulas.
Here's a tutorial:
http://www.officearticles.com/tutori...soft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com


"Robert Moore" wrote in message
link.net...
I have a spreadsheet that totals complaints per contractor each day.
The contractors get charged a fee per complaint. I want this fee to be
progressive, meaning, for example they would get charged $3.00 for the
first complaint, $4.00 for the second, $5.00 for the third, etc. The
number of complaints on any given day would usually be in the range from
1 to 10 per day. So if they had 5 complaints it would be 1*3+1*4+1+1*5+
etc up to 5 or a total charge of $25.00. Obviously another way to do
this would be to simply add 3+4+5+6+7. But I do want to be able to
alter the amount I charge them per complaint so it won't always be this
progression. For example, they may get their first complaint for free
and then the charges start, or perhaps the first 3 for free and then the
charges start...

Can you help me with a formula