IF statement, delimiters, blanks in spreadsheet

06102014, 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 

06102014, 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. 

06102014, 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. 

06102014, 04:28 AM
Post: #4




RE: IF statement, delimiters, blanks in spreadsheet
(06102014 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. 

06102014, 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 

06102014, 02:19 PM
Post: #6




RE: IF statement, delimiters, blanks in spreadsheet
(06102014 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. 

« Next Oldest  Next Newest »

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