The following warnings occurred:
Warning [2] count(): Parameter must be an array or an object that implements Countable - Line: 795 - File: showthread.php PHP 7.4.33 (FreeBSD)
File Line Function

 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
 jrozsas Member Posts: 158 Joined: Nov 2014
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.

Attached File(s)
PLAN1.zip (Size: 9.89 KB / Downloads: 10)
BGS_EST.hpappdir.zip (Size: 1.26 KB / Downloads: 8)

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)