How to write IF Formula

[Hongli1216]

Hi, I'm trying to write an IF formula for the below file: if column [Sep & Con] is Sep, then keep the numbers in column [State Apportionment %:]; if [Sep & Con] is Con, then make the numbers zero in column [State Apportionment %:] , except 1091 in column [CoCd]. I mean I want to keep all of the numbers in column [State Apportionment %:] for CoCd is 1091 no matte it's Sep or Con. I really appreciate your great help and your time! Thanks! Holly

Jurisdiction	Tax Year	Sep & Con	State Apportionment %:	CoCd
Alabama	2019	Sep	0.001498	1000
Alabama	2019	Sep	0.001498	1091
Alaska	2019	Con	0.000077	1000
Alaska	2019	Con	0.000077	1091
Arizona	2019	Con	0.002022	1000
Arizona	2019	Con	0.002022	1091

[jeff_reynolds · Accepted solution]

See if the attached workflow does what you're looking for. I basically split the problem in 2 pieces. Rows that we know we don't want to change, and those that may change. It could all be done in one formula, but this seems easier to me. Good luck. 

[markcurry · Accepted solution]

I think this might be what you're after....

IF [CoCd] = 1091 THEN
[State Apportionment %]
ELSEIF [Sep & Con] = "Con" THEN
0
ELSE
[State Apportionment %]
ENDIF

[jacob_kahn · Accepted solution]

Check out this feed here and here 

good luck 

J

[Hongli1216]

Hi Jeff,

Thanks for your quick help! It works. I combined yours and others and got the below formula: IF [CoCd]="1091" THEN [State Apportionment %:] ELSEIF [Sep & Con] ="Con" THEN 0 ELSE [State Apportionment %:] ENDIF. Appreciated your time! 

Holly

[Hongli1216]

Hi Mark,

I really appreciated your timely help! The formula is really amazing! Thanks! 

Holly