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