Bill Golden

asked on

# 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

=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,

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

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**
ASKER

Working on this project helps get through the chemo and radiation treatments. Some of you will never know how much EE has meant to me during this difficult time.

Thanks again!