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