T
TeeSee
=IF(A1 = 1 #OR#2,1,2)
What is the correct way to write the OR part of the formula? Thanks
What is the correct way to write the OR part of the formula? Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
=IF(OR(A1=1,A1=2),1,2)
Another:
= 2 - OR(A1=1,A1=2)
=IF(OR(A1=1,A1=2),1,2)
Another:
= 2 - OR(A1=1,A1=2)
K
Kevin B
=IF(OR(A1=1,A1=2),1,2)
C
Conan Kelly
TeeSee,
=IF(OR(A1=1,A1=2),1,2)
HTH,
Conan
=IF(OR(A1=1,A1=2),1,2)
HTH,
Conan
N
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
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
G
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
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
R
Ragdyer
Another way:
=If(Or(A1={1,2}),1,2)
=If(Or(A1={1,2}),1,2)