=IF(OR(A1=1,A1=2),100,200)

Means:
If A1 =1 or A1 =2 Then the result is 100, Else the result is 200

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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