IF Formula with Multiple Targets

[katherinetdavita]

I'm trying to create a formula for a set of demographic information to capture which people live and/or work in a set of specified counties and I've tried multiple variations of IF formulas with no success.

Here's some sample data. I'm trying to populate a new column called "Live/Work in Selected County" based on the work and home county fields. The four selected counties are Dutchess, Putnam, Rockland, and Westchester.

Looking for help with the syntax in the formula tool.

[markcurry · Accepted solution]

Hi @katherinetdavita  , I think the following formula should work for you...

IF [Work County] IN ("Dutchess","Putnam","Rockland","Westchester") AND [Home County] IN ("Dutchess","Putnam","Rockland","Westchester") THEN 
	"Live & Work"
ELSEIF [Work County] IN ("Dutchess","Putnam","Rockland","Westchester") THEN 
	"Work"
ELSEIF [Home County] IN ("Dutchess","Putnam","Rockland","Westchester") THEN 
	"Live"
ELSE
	Null()
ENDIF

[katherinetdavita]

Ah, that's amazing!! Thanks so much.