Thanks:  0
Likes:  0

1. Question:
Can I put an OR statement inside an IF formula?
if yes how would you use that?

2. 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?
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.

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

4. 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

5. 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

6. 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")

7. Yes it works
Thanks guys, I am very appreciated

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•