OR statement

[Guest]

Question:
Can I put an OR statement inside an IF formula?
if yes how would you use that?
Thanks in advance

 

[Aladin Akyurek]

On 2002-03-11 11:21, Anonymous wrote:
Question:
Can I put an OR statement inside an IF formula?
if yes how would you use that?
Thanks in advance

Example:

=IF(OR(A1="X",A1="Y"),A1*B1,0)

which says: if A1 is either equal to "X" or equal to "Y", give the result of A1*B1, otherwise 0 in the cell where this formula is.

 

[Mark W.]

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

 

[Eli Weiss]

for example put in b1:
=IF(OR(A1=1,A1=2),"y","n")
If a1 contains 1 or 2 then you get y
else n
Eli

 

[Guest]

I am using the Conditional Format
After selecting columnB,I typed in
=OR(c1="",c1="Test")
eg. change text in columnB to white if c1="" or c1=Test
However, it doesn't work
Should I add more statment in the formula
Thanks guys

 

[Mark W.]

On 2002-03-11 11:36, Anonymous wrote:
I am using the Conditional Format
After selecting columnB,I typed in
=OR(c1="",c1="Test")
eg. change text in columnB to white if c1="" or c1=Test
However, it doesn't work
Should I add more statment in the formula
Thanks guys

If you mean to test for an empty cell try this instead...

=OR(ISBLANK(C1),C1="Test")

 

[Guest]

Yes it works
Thanks guys, I am very appreciated