View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
shg[_5_] shg[_5_] is offline
external usenet poster
 
Posts: 1
Default 1 minus 1 doesn't equal 0 ?!!?!?


I agree with Sheloo for the OP's question as stated. Integers up to
+/-10^15 can be exactly represented in floating point, and the result
should (and does) sum precisely to zero if manually entered (as opposed
to being the result of a formula that could have rounding errors).


--
shg
------------------------------------------------------------------------
shg's Profile: http://www.thecodecage.com/forumz/member.php?userid=13
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=24483