Still not registering!

If your value is 85 then it meets all of these criteria:

85 - 95 value of 1
78 - 87 value of 2
84 - 96 value of 7
73 - 87 value of 9

Biff

"tzip123" wrote in
message ...

Here is what my "if then else statement" looks like right now - - where
A6 is the value being looked up

IF(AND(A6=J6,A6<=K6),3,IF(AND(A6=L6,A6<=M6),4,IF (AND(A6=N6,A6<=O6),5,IF(AND(A6=P6,A6<=Q6),6,IF(A ND(A6=R6,A6<=S6),7,IF(AND(A6=T6,A6<=U6),8,IF(AND (A6=V6,A6<=W6),9,"")))))))


--
tzip123
------------------------------------------------------------------------
tzip123's Profile:
http://www.excelforum.com/member.php...o&userid=31878
View this thread: http://www.excelforum.com/showthread...hreadid=516076