Search
Member List
Calendar
Help
HP Forums
/
HP Calculators (and very old HP Computers)
/
HP Prime 
/
Spreadsheet X Excel formula [Solved]
/
Spreadsheet X Excel formula [Solved]
|
Spreadsheet X Excel formula [Solved]
|
|
07-18-2016, 12:41 PM
(This post was last modified: 09-06-2016 11:33 AM by jrozsas.)
Post: #1
|
|||
|
|||
|
Spreadsheet X Excel formula [Solved]
I have a doubt regarding the spreadsheet, in a formula.
Excel , in column "G": =IF(A2<>"MC";IF(A2<>"PS";IF(E2>F2;E2-F2;" ");" ");" ") In HP Prime: =IFTE($A$2<>"MC",IFTE($A$2<>"PS",IFTE(E2>F2,E2-F2,""),""),"") Work Fine! OK But in cell "C3" in excel: =IF(A3="PS";F3+B3;IF(A3="MC";F3+B3;LOOKUP(2;1/(LEN(C2)>0);C2:C3))) how to make this formula into the calculator?Attached are the two files to excel and Prime hp I appreciate the help. Leo |
|||
|
|
« Next Oldest | Next Newest »
|
| Messages In This Thread |
|
Spreadsheet X Excel formula [Solved] - jrozsas - 07-18-2016 12:41 PM
RE: Spreadsheet X Excel formula - cyrille de brébisson - 07-19-2016, 05:05 AM
|
User(s) browsing this thread: 1 Guest(s)