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.
The formula first needs to first needs to check whether AB15 is north or south and then the second condition.