"OR" functions logical values

N

NIMN

if cell A1 is 4 OR 5
is

IF(OR(a1=4;a1=5);...)

But I wonder if there is something which allows to write:

a1=OR(4;5)

?

thanks
 
R

Ron Rosenfeld

if cell A1 is 4 OR 5
is

IF(OR(a1=4;a1=5);...)

But I wonder if there is something which allows to write:

a1=OR(4;5)

?

thanks
Click to expand...

You can use an array constant:

=OR(A1={4,5})
 
Top