Re: 17BII & 17BII+ Discounted Payback Period Revisited Message #3 Posted by Don Shepherd on 20 Nov 2013, 7:48 p.m., in response to message #1 by Tom Neudorfl
I entered Peter's equation into my 17bii and got an error message when I CALC'd. The error occurred at the 3 right parens before >=1E-15 at the end of line 18. I deleted one of those right parens (leaving 2 of them) and added a right paren after the 15, and it then CALC'd OK.
Apparently, the 17bii does not like it when you enclose the first expression in an IF statement in parens, but it's ok if you enclose the second expression (the one following the logical symbol) in parens. It looks like the 17bii+ must handle both of these ok.
The 17b has the same problem as the 17bii.
Ahh, I found the answer to this problem. In the 17b and 17bii manual is found the following caveat:
A conditional expression that contains within it an algebraic expression might cause the error INVALID EQUATION. If this happens, insert a + before the left parenthesis starting the algebraic expression. For example, change IF((A+2)/5<12: ... to IF(+(A+2)/5<12: ...
They must have fixed this in the plusses.
Edited: 20 Nov 2013, 10:49 p.m.
|