embarrassing spreadsheet question w/ rpn

[Jim Creybohm]

I read that the recent upgrade addressed many of the spreadsheet issues when using RPN. or did I read that? Regardless, after updating my Prime I find certain functions such as sum(), and others still do not work in RPN mode. sum(A1:A3) for example.

am I missing something? I have gotten that function to work in algabraic mode. does RPN mode need a named series or...?

[Joe Horn]

In RPN mode you need to quote algebraic expressions, e.g. 'sum(A1:A3)'

[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

[Tim Wessman]

I am not seeing what is not working here. SUM is another one of those "can take a large number of arguments" commands.

A1:A3 SUM(1) works, as does A1:A3 4 5 SUM(3). 'SUM(A1:A3' creates the formula and is equivalent to =SUM(A1:A3) in a normal spreadsheet.

How are you trying to enter it?

[CR Haeger]

Hi Tim,

If you were asking me, I have no issues with this. I did learn that entering the expression 'sum(A1:A3)' in RPN does not evaluate until Eval pressed.

Best,
Carl

[Tim Wessman]

Was asking the op. Sorry.

Are you doing that in the home screen? If so, then yes that is expected. In the spreadsheet itself '<formula>' is equivalent to =<formula> and should be automatically evaluating.