+- HP Forums (https://www.hpmuseum.org/forum)
+-- Forum: HP Calculators (and very old HP Computers) (/forum-3.html)
+--- Forum: HP Prime (/forum-5.html)
+--- Thread: Spreadsheet X Excel formula [Solved] (/thread-6575.html)
Spreadsheet X Excel formula [Solved] - jrozsas - 07-18-2016 12:41 PM
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.
RE: Spreadsheet X Excel formula - cyrille de brébisson - 07-19-2016 05:05 AM
hello,
Some variation on
Cell(pos(Cell_Range_With_Values, Value), Result_Column)
Should do the trick...
Cyrille