Multi Condition IF Statement

[chockalingam]

Hi Community - my statement below is not evaluating as expected.  Even when I have cities or expenses that do not match the condition they are still multiplied by the factor rather than returning to 0. 

Any suggestions would be helpful:

IF [City] = "Evanston" && [Expense Category] = "Shipping" &&

[CALMONTH] IN ('202301', '202401') THEN [Actuals]*.23 ELSEIF

[CALMONTH] IN ('202302', '202402') THEN [Actuals]*.24 ELSEIF

[CALMONTH] IN ('202303', '202403') THEN [Actuals]*.14 ELSEIF

[CALMONTH] IN ('202304', '202404') THEN [Actuals]*.26 ELSEIF

[CALMONTH] IN ('202305', '202405') THEN [Actuals]*.25 ELSEIF

[CALMONTH] IN ('202306', '202406') THEN [Actuals]*.27 ELSEIF

[CALMONTH] IN ('202307', '202407') THEN [Actuals]*.26 ELSEIF

[CALMONTH] IN ('202308', '202408') THEN [Actuals]*.26 ELSEIF

[CALMONTH] IN ('202309', '202409') THEN [Actuals]*.25 ELSEIF

[CALMONTH] IN ('202310', '202410') THEN [Actuals]*.25 ELSEIF

[CALMONTH] IN ('202311', '202411') THEN [Actuals]*.25 ELSEIF

[CALMONTH] IN ('202312', '202412') THEN [Actuals]*.26

ELSE 0

ENDIF

[binuacs · Accepted solution]

@chockalingam updated formula attached

[chockalingam]

Many thanks @binaucs - the formula update now works as I expected.

[Qiu]

@chockalingam 
We can also use a Filter first for [City] and [Expense Category] then apply your formula.