IF formula

[Greg KY]

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

 

[T. Valko]

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%))

 

[Satti Charvak]

Is this what you want:

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

 

[Greg KY]

I used the second one and works great Thanks

 

[Greg KY]

Works great Thank you
--
Greg KY

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

 

[T. Valko]

You're welcome. Thanks for the feedback!