Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Mar 17, 2021 06:14 PM
I have a column A with strings and columns B and C with formulas from column A.
I would like to create another column D which calculates the value from column B, but if an error occurs then receive values from column C instead of column B.
Then, the IF function should be… IF(formula(B) has a valid value, formula (B), formula ©).
How can I implement this?
It should consider #ERROR! as a ‘false’ condition.
Mar 31, 2021 04:31 PM
Hello @Jeongyong_Kim!
According to your description the below formula should accomplish what you are looking for:
IF(
ISERROR({Column B}),
{Column C},
{Column B}
)
Let me know if I can help provide any more help, and if this helped answer your question please mark it as the solution :white_check_mark: .