software

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% amp; so
on.
Excel 2000


Assuming that your table of values for ranges of discounts are in cells
D1:F3 with D having the starting amount, E have the upper amount and F
have the Discount, ie

1 100000 20%
100001 200000 19.5%
etc
etc
etc

Use the following formula:-

vlookup(A1,D1:F3,3,true)

This will return the discount to be used for the value entered in A1--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: www.excelforum.com/member.php...oamp;userid=17084
View this thread: www.excelforum.com/showthread...hreadid=500681Start 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

quot; wrote:

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

Hi Michael

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

--
Regards

Roger Govierquot; gt; wrote in message
...
gt; Not sure where to start, but here goes. I have been working on
gt; creating a
gt; cost estimate. Cell I29 is the total cost. Based on the value in
gt; this cell
gt; I would like to multiply it by a certain percentage. I have 16
gt; possiblies;
gt; $1-$100,000 = 20%, $100,001-$200,000 = 19.5%, $200,001 - $300,000 =
gt; 19% amp; so
gt; on.
gt; Excel 2000
Thanks for the help, I'll try these and see what I come up with. Mike

quot;Roger Govierquot; wrote:

gt; Hi Michael
gt;
gt; Try
gt; =20%-INT((I29-1)/100000)*0.5%
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;
gt; gt; wrote in message
gt; ...
gt; gt; Not sure where to start, but here goes. I have been working on
gt; gt; creating a
gt; gt; cost estimate. Cell I29 is the total cost. Based on the value in
gt; gt; this cell
gt; gt; I would like to multiply it by a certain percentage. I have 16
gt; gt; possiblies;
gt; gt; $1-$100,000 = 20%, $100,001-$200,000 = 19.5%, $200,001 - $300,000 =
gt; gt; 19% amp; so
gt; gt; on.
gt; gt; Excel 2000
gt;
gt;
gt;

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

quot; wrote:

gt; Thanks for the help, I'll try these and see what I come up with. Mike
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt; gt; Hi Michael
gt; gt;
gt; gt; Try
gt; gt; =20%-INT((I29-1)/100000)*0.5%
gt; gt;
gt; gt; --
gt; gt; Regards
gt; gt;
gt; gt; Roger Govier
gt; gt;
gt; gt;
gt; gt; quot;
gt; gt; gt; wrote in message
gt; gt; ...
gt; gt; gt; Not sure where to start, but here goes. I have been working on
gt; gt; gt; creating a
gt; gt; gt; cost estimate. Cell I29 is the total cost. Based on the value in
gt; gt; gt; this cell
gt; gt; gt; I would like to multiply it by a certain percentage. I have 16
gt; gt; gt; possiblies;
gt; gt; gt; $1-$100,000 = 20%, $100,001-$200,000 = 19.5%, $200,001 - $300,000 =
gt; gt; gt; 19% amp; so
gt; gt; gt; on.
gt; gt; gt; Excel 2000
gt; gt;
gt; gt;
gt; gt;