SUMIF Question
Thanks Ken,
I'll remember that.
-Minitman
On Sat, 6 Nov 2004 22:17:05 -0000, "Ken Wright"
wrote:
Anytime you do calculations in Excel that involve decimals you start to make it
hard if you need things to be exactly equal. Comes down to the problem of
expressing fractional numbers in binary format, and so it's usually easiest to
just round the data off using ROUND. Your data may well have been only
0.0000000000001 off due to the problem, but that's enough under certain
conditions to get a FALSE return with an x = x type scenario.
|