Spreadsheets and precision?

Bill Ricker bill.n1vux at gmail.com
Sun Sep 9 14:01:56 EDT 2007


> Oh.  I do see that now that I look.  This strikes me as completely
> counter-intuitive.  So, how to people do actual division in
> spreadsheets?  Does Excel suffer from this as well?

Yes.

Every spreadsheet since VisiCalc has done floating point division and
other basic numeric formuli in formulaic form as

  =3329.10/10

and used NamedFunctions() only for things without conventional (to
business folks) infix notation.

VisiCalc and Lotus 1-2-3 allowed
   +3329.10/10
and might figure out that
     3329.10/10
was NOT a date and work, but OO.o.C and "Excel" insist on = prefix for
any non-constant formula

-- 
Bill
n1vux at arrl.net bill.n1vux at gmail.com


More information about the gnhlug-discuss mailing list