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