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 |
Solved! Go to 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
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
Hi Mark,
I really appreciated your timely help! The formula is really amazing! Thanks!
Holly