Thread: Nested if then else statement
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tzip123
 
Posts: n/a
Default Nested if then else statement

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

Reply With QuoteReply With Quote