You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Greg KY" wrote in message
...
I used the second one and works great Thanks
--
Greg KY


"T. Valko" wrote:

Try one of these:

=B2*LOOKUP(B2,{0,1000,2000},{0.1,0.15,0.2})

=B2*IF(B2<1000,10%,IF(B2<2000,15%,20%))

--
Biff
Microsoft Excel MVP


"Greg KY" wrote in message
...
I need a formula that gives a value based on what is typed in cell b2.
Lets say b2 is less that 1000 I need it to multiply b2 by 10%, but if
it
between 1000 and 2000 then multiply by 15%, or if greater than 2000
multiply
by 20%

Can someone help me out with this. Thanks
--
Greg KY