That makes two of us! I’ve always used VO space to view/edit the formula.
> On Mar 25, 2015, at 8:16 AM, Alex Hall <mehg...@icloud.com> wrote: > > Option-return? I didn't know about that, thank you. I've been wondering how > to look at the formula, even for cells that *do* work. >> On Mar 25, 2015, at 12:54 AM, Tim Kilburn <kilbu...@me.com >> <mailto:kilbu...@me.com>> wrote: >> >> Hi, >> >> Not sure if there’s anything that will specifically say what the error is, >> but, I certainly could be wrong. I usually just press option-return on the >> cell displaying that error and look at the syntax and cell references. If >> you have a circular reference, that is, referring to the same cell that the >> formula is in, it will display that error for sure. There are likely other >> things like division by zero that may cause it as well, but, the circular >> reference is the only one I’ve seen first hand in testing. >> >> Later... >> >> Tim Kilburn >> Fort McMurray, AB Canada >> >> On Mar 24, 2015, at 21:13, Alex Hall <mehg...@icloud.com >> <mailto:mehg...@icloud.com>> wrote: >> >> Hi all, >> In a spreadsheet, I'm seeing "formula error" in some cells that have >> formulas. How do I see what the error is so I can correct it? Thanks. >> >> -- >> Have a great day, >> Alex Hall >> mehg...@icloud.com <mailto:mehg...@icloud.com> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to macvisionaries+unsubscr...@googlegroups.com >> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >> To post to this group, send email to macvisionaries@googlegroups.com >> <mailto:macvisionaries@googlegroups.com>. >> Visit this group at http://groups.google.com/group/macvisionaries >> <http://groups.google.com/group/macvisionaries>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to macvisionaries+unsubscr...@googlegroups.com >> <mailto:macvisionaries+unsubscr...@googlegroups.com>. >> To post to this group, send email to macvisionaries@googlegroups.com >> <mailto:macvisionaries@googlegroups.com>. >> Visit this group at http://groups.google.com/group/macvisionaries >> <http://groups.google.com/group/macvisionaries>. >> For more options, visit https://groups.google.com/d/optout >> <https://groups.google.com/d/optout>. > > > -- > Have a great day, > Alex Hall > mehg...@icloud.com <mailto:mehg...@icloud.com> > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to macvisionaries+unsubscr...@googlegroups.com > <mailto:macvisionaries+unsubscr...@googlegroups.com>. > To post to this group, send email to macvisionaries@googlegroups.com > <mailto:macvisionaries@googlegroups.com>. > Visit this group at http://groups.google.com/group/macvisionaries > <http://groups.google.com/group/macvisionaries>. > For more options, visit https://groups.google.com/d/optout > <https://groups.google.com/d/optout>. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
