Rounding When Autofill/Dragging

Hey Everyone,

Ran into a weird issue this morning that I can't figure out. I can find an easy way to bypass the issue using ROUND, but I'm curious if anyone knows what the problem is.

I'm working with a data set that starts at 826.79 and increases by increments of 0.01, so 826.79, 826.80, 826.81...
I started with the first few values and then dragged down to fill the rest of the data, but after the first 100 entries the values start to round. Example, in my data set once I reach 827.79 the next value should be 827.80, however it shows up in the formula bar as 827.799999988. This causes issues with using VLOOKUP.

Has anyone seen this before?

Thanks,

Rich

Sample Book.xlsx

Why not increment the values with a formula?
So in B2 enter =B1+0.01 and copy down.

BSB

Thanks BSB. As I said, I can easily get around the issue, it's more of a knowledge question I'm looking to have answered. I can't seem to find an explanation on any of the forums.

Perhaps a "floating point" issue?
Research that a little and see if anything turns up.

BSB