Brian Barker wrote:
At 21:30 10/11/2008 -0500, Tom Webb wrote:
Any chance that your 8 in D2 is actually entered as 7.999. If I plug
this into the cell D2, the array formula will give a result of 0.2857
(rounded to 4 decimal places).
Sorry, but this isn't so, in fact: as you'd expect, changing D2 from 8
to 7.999 changes the result of the array formula only slightly - from
0.304762 to 0.304733.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
The result 0.2857 looks like 2/7 rounded off. This looks to me as if
the 7.999 was truncated (rounded down) to 7 exactly and then used to
divide something. Webb should check whether data entered as integers is
saved as floating point, and whether his sheet is rounding off or
truncating data.
----Solo Owl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
