Question: How do i remove errors from a formula?

Answer: Use Iferror() around your formula to remove errors. See picture below.

iferror1.png

IFERROR(value;value_if_error) Returns value_if_error if expression is an error and the value of the expression itself otherwise