The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

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

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

Super Learner
0
Votes
1
Answer

1 Answer

365 Team
0
Votes

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!