Hello, folks-- POI has a particular behavior that differs from Excel and tends to trip up my users. Let's say there's an IF():
IF(cond1,ref1,0) If *cond1* is true, it should return the value of ref1, and if false, it should return 0. In Excel, if cond1 is false, 0 will be returned, regardless of what's in *ref1*. In POI, if ref1 is #REF, then evaluating the cell returns #REF, even if cond1 is false. As a result, ref1 has to be wrapped in IFERRORs. My questions are: 1) Do I have that correct? I've noticed this behavior repeatedly, and it can be a bear to figure out, but it's possible, of course, that I misunderstand what's going on. 2) Isn't that, essentially, a bug? Shouldn't the eval return what Excel would return? -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 [email protected] <[email protected]> www.PennyMacUSA.com <http://www.pennymacusa.com/>
