What formulas are you using ... and where are these formulas pasted ?

It would be best to post your original workbook that is having the issues. That way we can work
with the offending sheet/s & formula/s.

Oftentimes, rebuilding the workbook from scratch eliminates all of the errors ... which is an option you also have - rebuild the workbook from scratch.