Excel is unusable for finance or accounting.

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



Re. Excel's inability to calculate decimal numbers precisely, due to
(pardon a layman's poss. wrong wording) using floating-point math to
handle simple fractions and decimals (see thread 'Glaring Excel calc
bug' in this group), Harlan Grove on July 2 provided the same answer
Paul Lynde once did on Hollywood Squares:

Peter Marshall: Now listen carefully, Paul. If you have one it's a
moose. If you have two, it's a....?

Lynde: It's a mess!

Two rhetorical Q's:

1) How can anyone use Excel for finance, accounting, or many
applications with dollars & cents, decimals, or simple fractions?

2) Why don't the dopes who write Excel LET you select either FP or
decimal storage?

***

.



Relevant Pages

  • Re: Excel is unusable for finance or accounting.
    ... handle simple fractions and decimals (see thread 'Glaring Excel calc ... Paul Lynde once did on Hollywood Squares: ... How can anyone use Excel for finance, accounting, or many ...
    (microsoft.public.excel)
  • Re: Abolish Fractions?
    ... rules for calculating with fractions, he might have a decimal point, ... that operations with decimals would make sense. ... Am I just missing the joke? ... really is a kook. ...
    (sci.math)
  • Re: Abolish Fractions?
    ... If he had only been proposing not to teach all children all of the ... rules for calculating with fractions, he might have a decimal point, ... that operations with decimals would make sense. ... Am I just missing the joke? ...
    (sci.math)
  • Re: devreden
    ... Apparently, high school texts don't ... in my high school algebra 1 text about converting repeating ... We knew from grade school long division that some fractions ... give rise to repeating decimals (and if this is all that you're ...
    (sci.math)
  • Re: Abolish Fractions?
    ... later math, and so needs to be taught _early_, as early as possible, ... decimals are boring -- there is no ... except the underlying depth of fractions. ... The quality of math literacy of elementary school teachers is so low, ...
    (sci.math)