Post Reply 
IF statement, delimiters, blanks in spreadsheet
06-10-2014, 03:44 AM
Post: #1
IF statement, delimiters, blanks in spreadsheet
I would like to replicate the following spreadsheet command in the HP Prime spreadsheet

=if(a2="";"";ATAN(b2/a2))

if I divide by zero or a blank cell I get an error message. If I use the above command on a spreadsheet in my computer, the command clears the error messages so summation further down can still calculate.

I have tried using ',' or ';' as delimiters
I have tried suing "" or '' for blank cells, but nothing worked and there is nothing in the manual on this topic, and internet searches bore little fruit

thanks for the help
Find all posts by this user
Quote this message in a reply
06-10-2014, 04:04 AM
Post: #2
RE: IF statement, delimiters, blanks in spreadsheet
Try using this:

=IFTE(A2=0,"",ATAN(B2/A2))

You need to use the IFTE form of the IF statement in a spreadsheet. Note that the Prime spreadsheet treats a blank cell as zero for a numerical comparison. Also, it is ok to use lower case a2 for the cell address, but I like to use capital letters for consistency with the default cell column names.
Find all posts by this user
Quote this message in a reply
06-10-2014, 04:18 AM
Post: #3
RE: IF statement, delimiters, blanks in spreadsheet
Thanks Michael, that was great, it worked

BTW, is there any resource out there for the commands in the HP Prime Spreadsheet so I would have something of value to refer to . HP's 616 page document on the Prime only offered a small example on their spreadsheet and NO information about the various command there in.

again thanks for the help.
Find all posts by this user
Quote this message in a reply
06-10-2014, 04:28 AM
Post: #4
RE: IF statement, delimiters, blanks in spreadsheet
(06-10-2014 04:18 AM)resolved Wrote:  BTW, is there any resource out there for the commands in the HP Prime Spreadsheet so I would have something of value to refer to . HP's 616 page document on the Prime only offered a small example on their spreadsheet and NO information about the various command there in.

Other than using the Help button with the Toolbox Catalog, I know of none. Basically, most functions in the catalog, including CAS functions, will work in the Spreadsheet App, which makes it a lot more powerful than a computer spreadsheet such as Excel.
Find all posts by this user
Quote this message in a reply
06-10-2014, 05:51 AM
Post: #5
RE: IF statement, delimiters, blanks in spreadsheet
Hello,

>BTW, is there any resource out there for the commands in the HP Prime Spreadsheet.

Any 'normal' Prime function will work in the spreadsheet...

They are a couple of functions that behaves differently in the spreadsheet, these are the so called "multi return functions" which are listed in "MENU" key when in the spreadsheet.

cyrille
Find all posts by this user
Quote this message in a reply
06-10-2014, 02:19 PM
Post: #6
RE: IF statement, delimiters, blanks in spreadsheet
(06-10-2014 04:04 AM)Michael de Estrada Wrote:  Prime spreadsheet treats a blank cell as zero for a numerical comparison.

All spreadsheets do the same. It is actually a special 0. Many spreadsheets now normally hide the 0, but you can still get it without too much difficulty in excel for example.

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
Post Reply 




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