When I use a function (Col A) to compare a calculated difference (Col C) with the same number typed in (Col B), I get inconsistent results.
the formula being =B2=C2 0.04 =D2+E2 -0.61 0.65
Using other comparible formulas (=IF types) yield the same result.
There is a pattern but it changes
Has anyone any ideas? This has dashed my confidence in Excel.