* FX2L and FX2C can yield the wrong value for certain negative
integers (e.g. -2147483648). I think the numbers affected are
negative integers that have zeros in at least the bottom 16 bits (in two’s-complement representation). For such numbers, the errors occur
fairly frequently but not always. They seem to occur even more
commonly (maybe always) if the bottom 32 bits are zero. This only
seems to affect integer inputs, not non-integer numbers that round to
such integers.
The extended math commands allow 26 special Ultra 4 variables to
handle numbers ranging from negative 21 million to positive 21
million with up to two decimal places.
This allows you to calculate financial transactions without needing
the spreadsheet, or to do any other math which is beyond the range of
Ultra's normal 0-65535 limits.
One limitation is that the result of a multiplication or division can
not exceed 214,748.36, at least if you want an accurate answer.
Additions and subtractions work all the way up to the maximum value. Multiplications and divisions are limited because of the need to
maintain two decimal place accuracy.
Ed: Because of this "limitation" for multiplication or division I
would hesitate to use these extended math commands unless I knew for
sure that there was no chance my data could exceed the limitation.
Practice safe Hex, create a spreadsheet and do the calculations
there.
Here are the ranges. (The second columns have commas to make the
numbers more readable, but you can't use commas in your macros. You
must write the numbers as they appear in the first columns of each
group.)
Extended Variables Normal Ultra 4 (integers only) --------------------------------------------------------------
Lowest: -21,474,836.47 0
Highest: 21,474,836.47 65,535
What I don't understand is this -- supposedly the AppleWorks Spreadsheet doesn't suffer from these limitations, but I know for certain that it
uses the SANE package.
For some reason the math error and specifically the number 2147483648
struck a memory I had about a similar issue with UltraMacros for
AppleWorks.
I finally found that it was referenced in Joe L. Walter's UltraMacros Reference Manual. I've quoted it below, but don't really know if it<description from UltraMacros manual snipped>
will be of any help to you. If not, please disregard.
What I don't understand is this -- supposedly the AppleWorks
Spreadsheet doesn't suffer from these limitations, but I know for
certain that it uses the SANE package.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 546 |
Nodes: | 16 (0 / 16) |
Uptime: | 169:09:49 |
Calls: | 10,385 |
Calls today: | 2 |
Files: | 14,057 |
Messages: | 6,416,551 |