I’m trying to set up a formula in Airtable that will multiply two different values from separate fields, but I only want this calculation to happen when a specific checkbox field is marked as true.
For example, let’s say I have:
- Field A with numbers like 5, 10, 15
- Field B with numbers like 2, 3, 4
- Field C which is a checkbox
I want to create Field D that shows the result of A × B, but only when Field C is checked. If the checkbox isn’t selected, Field D should remain empty or show zero.
What’s the best way to write this conditional formula in Airtable? I’ve been struggling with the syntax and would really appreciate some guidance on how to structure this properly.
The formula’s pretty simple once you get it. Use IF to check your checkbox first, then do the math only when it’s checked. Here’s what works: IF({Field C}, {Field A} * {Field B}, 0). This checks if Field C (your checkbox) is marked - if yes, it multiplies Field A by Field B. If unchecked, you get 0. Want blank cells instead? Use "" rather than 0. I’ve used these conditional formulas in my project sheets and they’re solid. Just double-check your field names match exactly - spaces and special characters matter. The formula updates automatically when you check or uncheck the box.
Been using Airtable for years and hit this same issue building a pricing calculator for internal projects.
You want: IF({Field C} = 1, {Field A} * {Field B})
This keeps the cell empty when the checkbox is unchecked - way cleaner than zeros everywhere. The = 1 part explicitly checks for the checked state.
Learned this the hard way - if Field A or Field B is empty, you’ll get an error. If your data might have blanks, wrap it:
IF(AND({Field C}, {Field A}, {Field B}), {Field A} * {Field B})
This only calculates when the checkbox is checked AND both number fields have values. Saved me from tons of #ERROR cells with incomplete data imports.
Formula recalculates instantly when you toggle the checkbox, so it’s pretty responsive.