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 <[email protected]> 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 <[email protected] > <mailto:[email protected]>> 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 > [email protected] <mailto:[email protected]> > > -- > 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 [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > 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 [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > 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 [email protected] -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
