H Harlan Grove Sep 11, 2003 #2 Can this be done? Or do you need to know more (specifics)? Click to expand... If you mean something like =IF(AND({1,2,3,4}<=2,{1,3,2,4}<=2),{9,8,7,6}) with the result being (pseudosyntax) {9,FALSE,FALSE,FALSE}, then no. To do that you'd need to use =IF(({1,2,3,4}<=2)*({1,3,2,4}<=2),{9,8,7,6})
Can this be done? Or do you need to know more (specifics)? Click to expand... If you mean something like =IF(AND({1,2,3,4}<=2,{1,3,2,4}<=2),{9,8,7,6}) with the result being (pseudosyntax) {9,FALSE,FALSE,FALSE}, then no. To do that you'd need to use =IF(({1,2,3,4}<=2)*({1,3,2,4}<=2),{9,8,7,6})
J JMay Sep 11, 2003 #3 Thanks Harlan; Does your No 2 illustration need to be entered Ctr+Sft+Enter? TIA JMay
H Harlan Grove Sep 11, 2003 #4 JMay said: Thanks Harlan; Does your No 2 illustration need to be entered Ctr+Sft+Enter? .... Click to expand... Yes, array-entered into a range of corresponding shape and size.
JMay said: Thanks Harlan; Does your No 2 illustration need to be entered Ctr+Sft+Enter? .... Click to expand... Yes, array-entered into a range of corresponding shape and size.
