Formula condition

448 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello users!

I have a budget model with a field that automatically calculates state taxes based on the price I include for a given product. In some cases, though, I am not charged any taxes, and my budget doesn’t allow me to leave it as “$0.00” - How can I adjust it so that I can modify the value to $0 when no taxes are charged? See attached Screen Shot 2021-09-30 at 2.25.57 PM

1 Reply 1

You need a field that indicates whether taxes should be applied or not. Assuming that field is a Checkbox where a check means taxes should be charged, your formula would look like this:

IF({Checkbox}, {TOTAL} * 8.875/100, {Checkbox})