Forum Discussion
Using Copy/Fill Excel
I create a pattern to fill down. The pattern starts with 3.50%, in the next cell 3.75%. I select both cells and then use the copy/fill tool to copy down to 7.00%. After the fill, when I click on 6...
That's Floating-point arithmetic may give inaccurate result in Excel - Microsoft 365 Apps | Microsoft Learn which was in previous versions of Excel as well (and not only in Excel).
- Thanks. As I mentioned, this is a new behavior in Excel and why it starts at 6.25% doesn't make sense; I am dragging down (copy/fill) from a selection (3.5 & 3.75 are selected) so it should just continue to follow the pattern of increments at .25. What I am also noticing is that if I begin with a different value (10.5%, 10.75%) and copy down, it doesn't happen. Very odd. Thanks, again.
