"OR" functions logical values

[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

 

[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

You can use an array constant:

=OR(A1={4,5})

 

[NIMN]

THANKS!!!!!!

You can use an array constant:

=OR(A1={4,5})