If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

From this, we see that when formatted as an integer, cell C5 displays 250 when in fact the true number contained in that cell is 249.999999999942 as shown in cell C7 (when formatted as a 15-digit ...

Excel has a surprising limitation that you may not discover until you try to enter more than 15 digits in a cell. The application can only store numbers with15 digits of precision. If you enter a ...