Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula condition

180 1
Showing results for 
Search instead for 
Did you mean: 

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