Thread: Function Bug ?
View Single Post
  #4   Report Post  
swatsp0p
 
Posts: n/a
Default


I'm not good at explaining that, but it is the way binary computers deal
with decimal numbers. It probably has your number as nnn.089999999
instead of .09.

That is the quick and simple explanation. Someone may want to
elaborate on this.

Good Luck!

As a follow up, I am curious about your post: you list the following:
C12 8,187.14
C13 13,257.13
C14 50,297.36 =sum(C12:C13)


when in fact, C12+C13=21,444.27 not 50,297.36 Is this a typo? Just
wondering


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=385677