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.