Re: Excel is unusable for finance or accounting.

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Earl Kiosterud" <someone@xxxxxxxxxxx> wrote...
....
Could Exel do floating-point (or fixed-point, for that matter) in decimal?
Yes. But they don't. The processor can't do decimal math natively, so
it'd have to be done in software, slowing things down considerably.
....

Wrong. Excel already provides a fixed-point alternative, meaning scaled
integer math, and it *IS* natively supported, though it's still done in
binary rather than decimal (there being no difference for integer math per
se, just differences in the text representations), and it's about as fast as
IEEE floating point, perhaps even faster. However, fixed point provides less
precision than floating point once you begin dividing or exponentiating
numbers. Addition, subtraction and multiplication of integers always
produces integers.


.

Relevant Pages

  • Re: calculate problem in excel
    ... This is a fact of life that impacts almost all software, not just Excel. ... The math is correct, but the input numbers had to be approximated, so the final result is approximate. ... Excel only displays 15 digits, where you would need 17 digits to detect this approximation directly. ... do integer math ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Variable $i count a lot numbers...
    ... Sounds like you want integer math rather than floating point math. ...
    (perl.beginners)
  • Re: This calculation is just wrong / computer cant count!
    ... Then you need to go back to primary school mathematics classes! ... Millions of PCs need to be recalled because "the math is wrong". ... In integer math it is 0 ... In floating point math 0.833333 approximately ...
    (microsoft.public.vc.mfc)
  • Re: Weird calculation problem
    ... all computations are being done using integer math - and the results will be ... consider casting one variable to a double - and that will get the entire ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: 16 bit subtraction with ABS function
    ... you don't necessarily need fancy fixed-point math. ... hack it by doing 16-bit integer math and discard the low-byte when you ...
    (comp.sys.apple2.programmer)