Compare cells if not blank

Hello,
I'm trying to compare two cells (both containing a city) to see if they match but I don't want blank cells included. Thank you for any help. I'm sure it's easy, but I've already spent waaaay to much time trying to figure it out! π
Best Answer
-
Hi @Paula Cosentino,
Try this:
=IF(OR([Existing Clinic/Care Site City]@row = "", [New/Updated: Clinic/Care Site City]@row = ""), "", IF([Existing Clinic/Care Site City]@row = [New/Updated: Clinic/Care Site City]@row, "Match", "Not Match"))
All the best,
Sandra
Answers
-
Hi @Paula Cosentino,
Try this:
=IF(OR([Existing Clinic/Care Site City]@row = "", [New/Updated: Clinic/Care Site City]@row = ""), "", IF([Existing Clinic/Care Site City]@row = [New/Updated: Clinic/Care Site City]@row, "Match", "Not Match"))
All the best,
Sandra
-
You are my new best friend!!! Thank you for taking the time. This is perfect!
-
I am happy to help and also happy to make new friends. π
Hope you have a great day!
Sandra
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.8K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 485 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!