Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more 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
361 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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}
)

Thank you for your help!