Formula help

[serge]

What formula should be use to return 1 ?

if :

A1: 1
B1: 2
C1: 2
in that order ?
OR

A1: 0
B1: 2
C1: 3

I will have different column for each different return.

Thank you.

 

[jasonb75]

For the first, must be array confirmed with shift ctrl enter.

=--AND(A1:C1={1,2,2})

Same principal applies for the second and any other arrays.

 

[serge]

Hi Jason,

It worked like a charm, Thank you so much!!