Use of And(Cond1,Cond2) in Contol Array Entered Formulas

[JMay]

Can this be done?
Or do you need to know more (specifics)?
TIA,,

 

[Harlan Grove]

Can this be done?
Or do you need to know more (specifics)?

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})

 

[JMay]

Thanks Harlan; Does your No 2 illustration need to be entered Ctr+Sft+Enter?
TIA
JMay

 

[Harlan Grove]

Thanks Harlan; Does your No 2 illustration need to be entered Ctr+Sft+Enter?
....

Yes, array-entered into a range of corresponding shape and size.