Excel: 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.

This question generated 7 answers. To proceed to the answers, click here.

This thread is current as of December 13, 2014.

For more resources for Microsoft Excel