Correct Syntax

[TeeSee]

=IF(A1 = 1 #OR#2,1,2)

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

 

[JE McGimpsey]

One way:

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

Another:

= 2 - OR(A1=1,A1=2)

 

[Kevin B]

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

 

[Conan Kelly]

TeeSee,

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

HTH,

Conan

 

[Niek Otten]

=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

| =IF(A1 = 1 #OR#2,1,2)
|
| What is the correct way to write the OR part of the formula? Thanks

 

[Gord Dibben]

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

Note: this will return 1 if A1 is either 1 ot 2 and 2 if A1 is anything other
than 1 or 2.

Is that what you want?

Maybe =IF(A1=1,1,IF(A1=2,2,""))


Gord Dibben MS Excel MVP

 

[Ragdyer]

Another way:

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