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> 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 -- 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.
