+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: embarrassing spreadsheet question w/ rpn (/thread-620.html)
embarrassing spreadsheet question w/ rpn - Jim Creybohm - 02-06-2014 01:58 AM
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...?
RE: embarrassing spreadsheet question w/ rpn - Joe Horn - 02-07-2014 11:04 AM
In RPN mode you need to quote algebraic expressions, e.g. 'sum(A1:A3)'
RE: embarrassing spreadsheet question w/ rpn - CR Haeger - 02-07-2014 11:38 PM
(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
RE: embarrassing spreadsheet question w/ rpn - Tim Wessman - 02-11-2014 05:51 PM
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?
RE: embarrassing spreadsheet question w/ rpn - CR Haeger - 02-11-2014 08:40 PM
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
RE: embarrassing spreadsheet question w/ rpn - Tim Wessman - 02-11-2014 09:40 PM
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.