IF OR AND combination

scott-atkinson

I'm with the Witch.......

Local time

Today, 03:17

Joined

Aug 31, 2006

Messages

1,621

• Dec 28, 2007

• #1

Guys,

Is there a way that I can combine together a IF OR AND statement, and if so how?

 

wazz

Super Moderator

Local time

Today, 10:17

Joined

Jun 29, 2004

Messages

1,711

• Dec 28, 2007

• #2

IF x=y OR x=z AND y=n then...

include x= with each OR statement. IF x=y OR z AND y=n then... will not work.

 

scott-atkinson

I'm with the Witch.......

Local time

Today, 03:17

Joined

Aug 31, 2006

Messages

1,621

• Dec 28, 2007

• #3

wazz said:

IF x=y OR x=z AND y=n then...

include x= with each OR statement. IF x=y OR z AND y=n then... will not work.

Click to expand...

Sorry Wazz,

I do not understand, let me explain what I am trying to do.

Column 1 has text..."Sample Received", "Sample Approved" etc...
Column 2 has a date field.

I am trying to create a statement like this

If Col 1 <> sample received, or Col 1 <> Sample Approved, and Col 2 is < todays date, then "Chase sample".

How would I achieve this?

Thanks for your help.

 

Brianwarnock

Retired

Local time

Today, 03:17

Joined

Jun 2, 2003

Messages

12,701

• Dec 28, 2007

• #4

You have to correctly bracket your ANDs and ORs

if cols A and B have values then col C could have

=IF(AND(OR(A1="x",A1="Y"),B1="Z"),"TRUE","FALSE")

Brian