If Statement using greater than and less than

[robertsgw]

Hello. I am trying to write a formula using greater than and less than. If the number of items is 12, I want it to calculate the price based on the criteria below. So the math using 12 items would be 12*$3=$36. How would you write an if statement so it evaluates the number of items in the cell and multiples it by the correct dollar rate? Thanks.


0-10 Items = $2.00
11-15 Items = $3.00
16-20 Items = $4.00

 

[63falcondude]

How's this?

A2 =12
B2 =LOOKUP(A2,{0,11,16},{2,3,4})*A2

 

[Aladin Akyurek]

Hello. I am trying to write a formula using greater than and less than. If the number of items is 12, I want it to calculate the price based on the criteria below. So the math using 12 items would be 12*$3=$36. How would you write an if statement so it evaluates the number of items in the cell and multiples it by the correct dollar rate? Thanks.


0-10 Items = $2.00
11-15 Items = $3.00
16-20 Items = $4.00

Something like:

=A2*LOOKUP(A2,{0,11,16},{2,3,4})

where A2 houses a value like 12.