1906: Making Progress
Title text: I started off with countless problems. But now I know, thanks to COUNT(), that I have "#REF! ERROR: Circular dependency detected" problems.
| This explanation may be incomplete or incorrect: Still needs work - Please change this comment when editing this page. Do NOT delete this tag too soon.|
If you can address this issue, please edit the page! Thanks.
In the title text she reveals that even her spreadsheet has a problem, because "#REF Circular Dependency detected" is a spreadsheet error meaning that a formula is (possibly indirectly) using its own cell in the equation. This is because she has used the Count() function to find the number of problems to be solved, but since one of those problems is not knowing how many problems she has, it is trying to include itself in the count.
Arguably, this has introduced a further problem, so she actually now has (#REF Circular Dependency detected)+1 problems. It's also possible, since Megan has chosen to interpret the error message as a numeric value representing the number of problems she has, that she simply is not good at using her spreadsheet software, which may be another problem that needs adding to her list. The use of COUNT() has, rather than returning an exact amount of problems to solve, implied that her original problems cause so many more that she does indeed have "countless problems".
- [Megan is sitting and looking at a laptop.]
- Megan: I started the day with lots of problems.
- Megan: But now, after hours and hours of work,
- Megan: I have lots of problems in a spreadsheet.
add a comment! ⋅ add a topic (use sparingly)! ⋅ refresh comments!