Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Consider #ERROR as an IF condition

Topic Labels: Formulas
816 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeongyong_Kim
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Reply 1

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: .