Can I do simple math?

517 3
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

In Google Sheets, I do this in a cell:


...and the answer is output in the cell.

Can I do that in AirTable? To be clear, I want to have different formulas in each cell, not one formula for the whole column.

3 Replies 3

Hi @philraymond ,

It will be one formula per column always.  This is a good thing as it takes away the Sheets chaos...

Now to do math like above, you just create column A with free number input, column B with free number input and column C with fixed formula A * B.

If that math is not sufficient you create additional field D "Calculation type" - with single select containing "Add", "Substract" or "Multiply by 3 and deduct 1"  and then you upgrade the formula in column C to something like:

SWITCH("Calculation type",
"Add", A+B,
"Substract", A-B,
"Multiply by 3 and deduct 1", (A+B)*3-1

I hope that helps!

No you cannot do this in Airtable. One of the differences between a spreadsheet and a database is that each editable cell value should be an “atomic” value, the smallest piece of meaningful data. When you have an expression like 1+1, you have multiple bits of meaningful data that you want to combine. If you find yourself wanting to do this often, you might want to revisit your base design. 

5 - Automation Enthusiast
5 - Automation Enthusiast

Both helpful answers, thanks very much.