Thread: SUMIF Question
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Minitman[_4_] Minitman[_4_] is offline
external usenet poster
 
Posts: 273
Default 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.