Skip navigation

evaluate formula option in number

247 Views 3 Replies Latest reply: May 13, 2013 10:37 AM by Jerrold Green1 RSS
JonFlit Calculating status...
Currently Being Moderated
May 13, 2013 5:29 AM

Is there an option to evaluate a formula like in excel, so you can see each step in a formula so to check it works correctly?

MacBook Pro (13-inch, Mid 2012), OS X Mountain Lion (10.8.2)
  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    May 13, 2013 6:44 AM (in response to JonFlit)



    No, Numbers doesn't have an expression evalation option. It does color-code the cell references and highlight the matching cells in the same color. I make a habit of writing complicated expressions in stages, inner calculations first, then wrapping these preliminary expressions in successive layers of other functions.



  • jaxjason Level 4 Level 4 (3,320 points)
    Currently Being Moderated
    May 13, 2013 10:01 AM (in response to Jerrold Green1)

    The process i use for really complex equations is similar to Jerrys but a allows me to see the result of each step, just like in the excel evaulator... Placing the inner most equation/function in the first column, then each outward moving one to the right. When done, i cna literally copy/paste the left equation into the right in teh proper place and do that all the way down. If you wrap all your equations in () then it is really easy.



  • Jerrold Green1 Level 7 Level 7 (28,190 points)
    Currently Being Moderated
    May 13, 2013 10:37 AM (in response to jaxjason)



    You make a good point. I do that too, for really complex expressions.




More Like This

  • Retrieving data ...

Bookmarked By (0)


  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.