Here's the deal:
I have 4 cells: cell1 = 53711.83
cell2 = 53711.83
cell3 = 69.12
cell4 = 69.12
When I use a formula = (cell1+cell3-cell2-cell4)/31.25 I should get 0. Instead I get 0.0000000000000836735125631094.
Cells 1-4 are based on a dsum. I checked these cells and my original data out to 30 decimal places and I can't figure out where my problem is. I have the same setup in several places in my spreadsheet and in some places the formula works as it should, in a few places it doesn't. Where are these extra #s coming from? Any Ideas? Thanks in advance
Bookmarks