Ok everything works great, Now heres the next step. I have 2 tables. I
need a check box to select one or the other to use in the estimate. Thanks
Mike

" wrote:

Thanks for the help, I'll try these and see what I come up with. Mike

"Roger Govier" wrote:

Hi Michael

Try
=20%-INT((I29-1)/100000)*0.5%

--
Regards

Roger Govier


"
wrote in message
...
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