Thanks:  0
Likes:  0

# Thread: 2 conditionals and or statement

1. ## 2 conditionals and or statement

How can i write a formula for the following; if AB15="north" and AX<90 then "north" if false "south" OR if AB15="south" and AX<90 then "south" if false "north"

The formula first needs to first needs to check whether AB15 is north or south and then the second condition.

2. ## Re: 2 conditionals and or statement

Try rather to describe the problem instead of suggesting a solution or a formula...

When AB15 = north and AX15 < 90 --> north
When AB15 = south and AX15 < 90 --> south

What must happen when AB15 = north or south and AX15 >= 90 ?
What must happen when AB15 is neither north or south?

3. ## Re: 2 conditionals and or statement

Sorry, i wasn't trying to make a suggestion I was trying to describe the logic. AB15 will always be north or south and that is what the second condition is based on. That's why i said it needs to check first whether it is north or south. Sorry for the confusion....
Originally Posted by y3tter
if AB15="north" and AX<90 then "north" if false "south" OR if AB15="south" and AX<90 then "south" if false "north"

The formula first needs to first needs to check whether AB15 is north or south and then the second condition.
Try rather to describe the problem instead of suggesting a solution or a formula...

When AB15 = north and AX15 < 90 --> north
When AB15 = south and AX15 < 90 --> south

What must happen when AB15 = north or south and AX15 >= 90 ?
What must happen when AB15 is neither north or south?

4. ## Re: 2 conditionals and or statement

Try to answer the questions though...

5. ## Re: 2 conditionals and or statement

I did in OP and I bolded it in the reply.

What must happen when AB15 = north or south and AX15 >= 90 ? IF AB15 is north and AX15 is greater then "south" IF AB15 is south and AX15 is greater then "north
What must happen when AB15 is neither north or south?It will always be either north or south, that's why i wrote it must check that value first

6. ## Re: 2 conditionals and or statement

I looks like

=IF(OR(AND(AB15="north", AX<90), NOT(AND(AB1="south", AX<90))), "north", "south")

7. ## Re: 2 conditionals and or statement

Originally Posted by mikerickson
I looks like

=IF(OR(AND(AB15="north", AX<90), NOT(AND(AB1="south", AX<90))), "north", "south")
Great!!!! Thank you so MUCH!!

## 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
•