Automate tech support ticket status assignment by combining location and diagnostic criteria using nested IF and AND functions.