| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert row to EXACT function | Excel Worksheet Functions | |||
| Function to find only exact matches in spreadsheets? | Excel Worksheet Functions | |||
| EXACT function | Excel Discussion (Misc queries) | |||
| MATCH function - 2 columns w/ SIMILAR, not EXACT data | Excel Worksheet Functions | |||
| Use of Exact(or other) function for alternate rows? | Excel Worksheet Functions | |||
Threaded Mode
