Stuart McLachlan
stuart at lexacorp.com.pg
Wed Apr 25 09:15:25 CDT 2007
On 25 Apr 2007 at 9:18, Susan Harkins wrote: > Was playing around with AutoFill this morning and entered 1, 2, and 4, > expecting AutoFill to return 5, 6, and 8 -- but got 5, 7, and 8. > > I'm sure Excel is doing what it's supposed to do and the failing is my > understanding -- I don't think there's anything wrong, I'd just like to > understand why it gave me the results it did so I can get the results I > want. :) You must have had the column format constrained. What is is actually giving you is: 1.000 2.000 4.000 5.333... 6.833... 8.333... As my old text books used to say: Why it returns intervals of 1.33..., 1.5, 1.5, 1.5..... is left as an exercise for the reader ;-) -- Stuart