Last answered:

13 Jul 2020

Posted on:

11 Jul 2020

0

Why do I have the green error signs even when my answers are correct?

1 answers ( 0 marked as helpful)
Instructor
Posted on:

13 Jul 2020

0
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!

Submit an answer