Both "And" & "Or" in one If Statement

P

Paul Silverman

Hi Folks,

I'm trying to combine an "If(And" and "If(Or" statement into one "If"
statement.

I've been doing my And/Or Statements as two seperate If statements and they
work fine, But how can I combine them into one?

All help or examples gratefully accepted.

Thanks,

Paul Silverman
Melbourne
Australia
 
A

Arvi Laanemets

Hi

It depends of what you do want to achieve. So more details are needed to
give some advice.

One possible example:
=IF(OR(AND(LogicalExpr1,LogicalExpr2),AND(LogicalExpr3,LogicalExpr4),Respons
e1,Response2)
returns Response1, whenever both LogicalExpr1 and LogicalExpr2 or both
LogicalExpr3 and LogicalExpr4 are true.
But there are an infinite number of combinations.


Arvi Laanemets
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
IF statement not returning correct answer 3
& combine two array statements 3
Multiple arguments 3
VBA word change keys 0
Help on combining two IF statements 3
Multiple IF statements, macro stops at first True 0
Using @ in comments: is there a way to get only one email? 0

Top