selection

[Guest]

good day,

A
1
2
3

What I want are as follows if B1 = 1,2 or 3 it should show as true under
the "and" formula.
rgds
jules

 

[T. Valko]

Not sure what you mean by: it should show as true under the "and" formula.

Maybe you mean this:

=OR(B1={1,2,3})