How to enter spreadsheet formula while in RPN mode?

07042015, 03:09 PM
Post: #1




How to enter spreadsheet formula while in RPN mode?
I have tried with and without single quotes to enter a formula in a spreadsheet cell and continually get the always informative 'Error: Syntax Error' when the Home screen is set to RPN input. While with the input set to algebraic it works without error.
Example: set the contents of A1 to 42, then attempt to set A2 using '=A1' [either with or without the quotes] 

07042015, 03:20 PM
Post: #2




RE: How to enter spreadsheet formula while in RPN mode?
try 'A1'


07042015, 06:38 PM
Post: #3




RE: How to enter spreadsheet formula while in RPN mode?  
07042015, 08:17 PM
(This post was last modified: 07042015 08:55 PM by Tim Wessman.)
Post: #4




RE: How to enter spreadsheet formula while in RPN mode?
(07042015 06:38 PM)norlesh Wrote:(07042015 03:20 PM)rgallier Wrote: try 'A1' The spreadsheet =formula syntax *is* the equivalent of a 'expression' in rpn. Aka  you are making an algebaric expression. Use the shifted ( ) function to insert ''. Then type your expression inside of the to quote the arguments. TW Although I work for the HP calculator group, the views and opinions I post here are my own. 

07052015, 04:47 PM
Post: #5




RE: How to enter spreadsheet formula while in RPN mode?
Thanks Tim, sorry rgallier  didn't realize you meant to include the quotes. Your solution did work.


« Next Oldest  Next Newest »

User(s) browsing this thread: 1 Guest(s)