Hello -

I am trying to do a simple formula to calculate sales tax if a checkbox column is checked. I keep getting an error when I try to use the IF function. Here is my basic formula:

({Price}*{Quantity})*“.1025” - This calculates 10.25% sales tax on the total price.

How do I get it to recognize the {Taxable} checkbox to determine if the formula applies to that item?

Hi @Annalisa - the following should work:

ROUND(IF({Taxable},({Price}*{Quantity})*0.1025,0),2)

This will return a 0 if the Taxable checkbox is not checked.

Thanks,

Mark

2 Likes

Thank you!

Follow-up question: Is there a way to get it to show only two decimals without rounding? Ex: If the tax rate that’s it’s calculating ends up being $0.408, but I only want to view it as $0.40?

No Problem @Annalisa. You can use the TRUNC() function instead of ROUND() to retain two decimal places without rounding.

TRUNC(IF({Taxable},({Price}*{Quantity})*0.1025,0),2)

Thanks,

Mark