2 conditionals and or statement

y3tter

Board Regular
Joined
Nov 11, 2012
Messages
147
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.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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?
 
Upvote 0
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....
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?
 
Last edited:
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,492
Messages
6,113,967
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top