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 |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
IF statement, delimiters, blanks in spreadsheet - resolved - 06-10-2014 03:44 AM
RE: IF statement, delimiters, blanks in spreadsheet - Michael de Estrada - 06-10-2014, 04:04 AM
RE: IF statement, delimiters, blanks in spreadsheet - Tim Wessman - 06-10-2014, 02:19 PM
RE: IF statement, delimiters, blanks in spreadsheet - resolved - 06-10-2014, 04:18 AM
RE: IF statement, delimiters, blanks in spreadsheet - Michael de Estrada - 06-10-2014, 04:28 AM
RE: IF statement, delimiters, blanks in spreadsheet - cyrille de brébisson - 06-10-2014, 05:51 AM
|
User(s) browsing this thread: 1 Guest(s)