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?
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?