Complex Conditional Cost Expression

[appsheeter]

I have rule for each state to calculate filing costs based on number pages.

Is it possible to implement the rule in the cost column using an expression in that column only?

If [STATE] = "Oklahoma" take the page count and do this rule....

If [STATE] = "Kansas" take the page count and do this rule....

[TeeSee1 · Accepted solution]

Use IFS() or SWITCH()