IF formula
 

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

IF formula
 

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

IF formula
 

Is this what you want:

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


--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Greg KY" wrote:

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

IF formula
 

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

IF formula
 

Works great Thank you
--
Greg KY


"Satti Charvak" wrote:

Is this what you want:

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


--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Greg KY" wrote:

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

IF formula
 

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