IF statement ?

**tryingtothink** · 12-02-2007, 04:57 PM

i'm stuck on the last part of a spreadsheet i'm working on. seems like it should be pretty simple but i just can't figure it out. can't seem to find an answer via F1 or google.

lets say the value of A1 is labeled "Qty" and A2 is labeled "Discount Tier". i need to place a formula in A2.

if the value in A1 is less than 10, the number returned in A2 needs to be 1.
if the value of A1 is between 10 and 14, the number returned in A2 needs to be 2.
if the value of A1 is greater than 14, the number returned in A2 needs to be a 3.

so for example, a qty of 16, would be in Discount tier 3.

i have tried things like:

=IF(A1>9,2,IF(A1>14,3,1))

but i'm just making a mess of things now...

any help would be greatly appreciated.

**VBA Noob** · 12-02-2007, 04:59 PM

Maybe

=LOOKUP(A1,{0,10,15},{1,2,3})

VBA Noob

**tryingtothink** · 12-02-2007, 05:04 PM

my god that was fast! and it works!

i knew about vlookup but how is this working so easily? is there a link you can direct me to or something i can reference in the help file?