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