Formula condition

[Jahsun_Daher_Go]

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

[Kamille_Parks]

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})