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

Maybe you mean this:

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


--
Biff
Microsoft Excel MVP


"ekkeindoha" wrote in message
...
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