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

[Sidney_ML]

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.

[kuovonne]

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]

Thank you for your help!