Start by creating a table somewhere in your workbook, somewhere it will not
be seen, in the first column enter each amount that will trigger a different
percentage with the corresponding percentage in the second column. The table
should look like this:

Col(A)-Col(B)
0 - 20%
100,001 - 19.5%
200,001 - 19%
and so on, in an ascending order

Then use something like:
=A1*VLOOKUP(A1,your_table,2,1)

HTH
JG

" wrote:

Not sure where to start, but here goes. I have been working on creating a
cost estimate. Cell I29 is the total cost. Based on the value in this cell
I would like to multiply it by a certain percentage. I have 16 possiblies;
$1-$100,000 = 20%, $100,001-$200,000 = 19.5%, $200,001 - $300,000 = 19% & so
on.
Excel 2000