Post Reply 
How to enter spreadsheet formula while in RPN mode?
07-04-2015, 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]
Find all posts by this user
Quote this message in a reply
07-04-2015, 03:20 PM
Post: #2
RE: How to enter spreadsheet formula while in RPN mode?
try 'A1'
Find all posts by this user
Quote this message in a reply
07-04-2015, 06:38 PM
Post: #3
RE: How to enter spreadsheet formula while in RPN mode?
(07-04-2015 03:20 PM)rgallier Wrote:  try 'A1'

That only assigns the current value of A1 instead of linking the cell so the formula can update with changes.
Find all posts by this user
Quote this message in a reply
07-04-2015, 08:17 PM (This post was last modified: 07-04-2015 08:55 PM by Tim Wessman.)
Post: #4
RE: How to enter spreadsheet formula while in RPN mode?
(07-04-2015 06:38 PM)norlesh Wrote:  
(07-04-2015 03:20 PM)rgallier Wrote:  try 'A1'

That only assigns the current value of A1 instead of linking the cell so the formula can update with changes.

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.
Find all posts by this user
Quote this message in a reply
07-05-2015, 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.
Find all posts by this user
Quote this message in a reply
Post Reply 




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