Adding Additional Column from Formula

chughes49

I currently have this

Fac Name	MonthAct	MonthVar
Main	2345	412
Elk	23542	312
ein	213	123
emc	412	142

I am trying have this though:

where there is a new column (Entity)

and if fac name=main Philly

and if facname=elk than it gives Mont

I am stuck right here:

IF([Fac name] IN(Main) THEN 'Philly')

Thanks!!

Entity	Fac Name	MonthAct	MonthVar
Philly	Main	2345	412
Philly	Elk	23542	312
Mont	ein	213	123
Mont	emc	412	142

DataKyle

So you need something like this?

IF([Fac Name] = 'Main') THEN 'Philly'

ELSEIF([Fac Name] = 'Elk') THEN 'Mont'

ELSE NULL ENDIF

You can also add other options before the last else if needed.