One helluva IF statement

[Adam]

I'm trying to write an IF statement, I want it to assign
a number value to a range of numbers based on another
cell (ie. if AA2 = <999=1, 1000<2999=2, 3000<5999=3 and
so on) Could someone get me started?

 

[Aladin Akyurek]

D25 houses a lookup table that houses your value assignment scheme:

{-9.99999999999999E+307,1;1000,2;3000,3;6000,4}

=LOOKUP(A2,$D$2:$D$5,$E$2:$E$5)

reads off/fetches the value from the lookup table that is associated with
the value in A2.
..

 

[Dale]

How high are you going?

It seems to me that you would be better off with a LOOKUP
table, then you could have your value range in one
column, and your response in the next.

Do a lookup for AA2 & Bob's your uncle!


Dale