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

  • Thread starter Thread starter Paul Silverman
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

& combine two array statements 3
Help on combining two IF statements 3
Can I combine IF/AND/OR statements? 8
XL2000: Depdendent Validations and IF Statement 3
MATCH not working in IF statement 6
if statements 3
Max amount of "IF" statements 2
Creating a dynamic IF statement 2

Back
Top