IF formula

  • Thread starter Thread starter Greg KY
  • Start date Start date
G

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
 
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%))
 
Works great Thank you
--
Greg KY


Satti Charvak said:
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
Click to expand...
 
Back
Top