evaluate formula option in number

Jon,

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.

Jerry

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.

Jason

Jason,

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

Jerry