Another way:

=If(Or(A1={1,2}),1,2)

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"TeeSee" wrote in message
...
=IF(A1 = 1 #OR#2,1,2)

What is the correct way to write the OR part of the formula? Thanks