Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

If the number in column A is greater than the number in Column B, then it should be inserted into column C

Topic Labels: Formulas
1442 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sidney_ML
4 - Data Explorer
4 - Data Explorer

New to Airtable and loving it so far! I am creating a Table for calculating costs and processing invoices for a logistics company. I am looking for a formula that will give me the result below:

If the number in column A is greater than the number in Column B, then it should be inserted into column C. BUT if the number in Column A is less than that in Column B, the Column B number should be inserted into Column C.

In other words, the greater of the numbers in Columns A and B should be inserted into column C.

Any help would be appreciated.

2 Replies 2

Welcome to the community!

You want {column C} to be a formula field with IF function.

IF(
  {column A} > {column B},
  {column A},
  {column B}
)
Sidney_ML
4 - Data Explorer
4 - Data Explorer

Thank you for your help!