One helluva IF statement

  • Thread starter Thread starter Adam
  • Start date Start date
A

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?
 
D2:D5 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.
..
 
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
 
Back
Top