Merging two working formulas

I have the following working formula

=IF($Q$11<>""," "&$Q$11&" ","You must enter a the Company's City and State in Q11!")

Which yields City, State & Zip Code, i.e. New York City, New York 12345

And this formula

=LEFT($Q$11,FIND("",$Q$11,FIND(", ",$Q$11)+3))

Which yields City and State with no Zip Code, i.e. New York City, New York

I need to combine the second formula with the first formula.  A snippet with all pertinent cells is attached.
EE-Snippet-CalcXLM-Report-Zip-Code-.xlsm