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
Bad Me! <sigh>. I neglected to check my double check(which was in
place). I was playing around with the OP's orginal eguation, by
breaking it up into segments, then seeing what would have to change
within it to get his odd result with the array formula. Then see if it
could be reproduced using the array formula you had provided. The fact
that I had misread it did not help (decimal point off by ten). It was
just too late in my day to be playing with numbers, but array formulas
intrigue and baffle me I haved used them but do not fully understand
them. I usually leave work cross-eyed and brain-dead from collecting
and analyzing print attributes, etc. Sorry for the misinformation.
Back to lurking in the shadows.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
