Skip to main content

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.

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!


Reply