View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SB SB is offline
external usenet poster
 
Posts: 1
Default MOD function not returning exact zero

Hi there!

I am working with the excel MOD function.
MOD(n,d)

n = 2929.68750000
d = 418.5267857

I expect the answer to be zero.
However, Excel is returning: -5.68434E-14

I have numerous incidences of this in my spreadsheet and
these values are messing up the worksheet

How does this occur and, more importantly, is there any way to
resolve this?

Regards
SB