Forum Discussion
Excel randomly flagging a result equal to 0.0005 when supposed to flag >0.0005
Hi there, I use excel to calculate weight differences on filtration papers. Basically, samples are heated once, weighed, reheated, and weighed another time. Difference has to be less than or equal...
Binary and Decimal arithmetic can have slight differences.
The numbers returned by your formulas may be slightly larger or smaller than it what is displayed.
Format your numbers to display 15 decimal places just to see what is going on.
The solution would be to alter your criteria (0.0005001 for instance) or to Round the numbers to 4 places.
'---
Nothing Left to Lose
https://1drv.ms/u/s!Au8Lyt79SOuhZw2MCH7_7MuLj04?e=sAwbHU
(free excel programs)