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