| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
