Question: how do i ignore all formula errors in excel?
Answer: Select the top-left first cell in the sheet that has the green triangle indicating the error.
Scroll to the last bottom-right cell that has the error. ... 
Go back to that first cell, there will be a clickable icon to do something about the error.
Click on it and then click "Ignore Error"