Skip to main content

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.

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

Reply


Terms & Conditions