I need help creating a formula field in Airtable that will multiply two different values together, but only when a checkbox is marked. Here’s what I’m trying to do:
- I have a field with numeric values (let’s call it Price)
- I have another field with numeric values (let’s call it Quantity)
- I have a checkbox field that needs to be checked for the calculation to happen
Basically, I want the formula to multiply Price × Quantity, but only if the checkbox is ticked. If the checkbox is not checked, I want the result to be blank or zero.
What would be the correct formula syntax for this kind of conditional calculation in Airtable? I’ve tried a few approaches but can’t seem to get it working properly.
The formula you’re looking for is: IF({Checkbox Field}, {Price} * {Quantity}, ""). This will perform the multiplication only when the checkbox is checked; otherwise, it returns blank. If you prefer to return zero instead of a blank result, simply switch the empty quotes with 0. I often apply this in my own Airtable setups for various workflows. It’s crucial that both Price and Quantity are formatted as numbers, not text, to ensure the calculation functions properly. Additionally, ensure the checkbox field name matches exactly since Airtable is case-sensitive. One thing to keep in mind is that if either Price or Quantity is empty, it will yield a blank result even if the checkbox is checked, so you may need additional conditions based on your specific requirements.