Why do I have the green error signs even when my answers are correct?
1 answers ( 0 marked as helpful)
Hi!
We have a lecture on how to remove these.
This is Excel's automatic auditing tool, which sometimes thinks there are inconsistencies between formulas.
Whenever there are formulas, which are in the same array but are not built with the same logic, Excel highlights you might be facing an error. But truth of the matter is that in most cases there isn't an error.
Go to Settings --> Formulas --> Disable background error checking.
Thanks!