I’m trying to create a formula field that’ll output a sales tax amount based on another field in the base.
So:
IF {Tax Type} = HST, multiply {Subtotal} by 13%,
IF {Tax Type} = GST, multiply {Subtotal} by 5%,
IF {Tax Type} = “Zero-rated”, type “0%”, else leave BLANK
I’ve tried several iterations of this nested IF statement and always have issues.
The latest was:
IF(
{Tax Type} = “HST”, “13%”,
IF(
{Tax Type} = “GST”, “5%”,
IF({Tax Type} = “Zero-rated”,
“0%”, BLANK
)
)
)
And I keep getting errors about the closing parenthesis, however, this was based on the Airtable Support article for nesting three or more IF statements in a row, so I’m confused.
Can anyone help? Thx.