embarrassing spreadsheet question w/ rpn

[CR Haeger]

(02-07-2014 11:04 AM)Joe Horn Wrote:  In RPN mode you need to quote algebraic expressions, e.g. 'sum(A1:A3)'

Joe - thanks for the tip.

Specifically, in RPN mode you can enter 'sum(A1:A3)' in the command line and hit Enter. For me, this loaded 1: sum(A1:A3) but did not evaluate. I had to hit Eval to generate the sum.

In the spreadsheet APP that A1:A3 was referred to, entering =sum(A1:A3) in a cell generated the numerical result whether or not I was in RPN or ALG modes.

Best,
Carl