Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 22, 2020 04:11 PM
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.
Apr 22, 2020 07:43 PM
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}
)
Apr 23, 2020 08:46 PM
Thank you for your help!