View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Adam Lawrence Acoustics[_2_] Adam Lawrence Acoustics[_2_] is offline
external usenet poster
 
Posts: 3
Default SumIf not working over a long range

Thanks, I tried a Copy-PasteValues-RemoveFormatting to check, and indeed it
turns out that a simple subtraction 75.2(exactly) - 75.3(exactly) =
-0.0999999999999943(!)

So, that answers one question, but poses another one!

Adam