Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding numbers for match function
I should add that I am using the "MROUND" function to round z* to multiples
of 0.2. All is fine for 0.2, 0.4, 0.8, and 1, but NOT for 0.6 and 1.2 (?!?) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
rounding numbers for match function
It is not clear exactly what calculation is failing, but 0.2 (along with most
floating ponit numbers) has no exact binary representation, hence MROUND(x,.2) may produce unexpected results. This is a natural consequence of the way computers represent numbers, and is not unique to Excel. Jerry "erc_blair" wrote: I should add that I am using the "MROUND" function to round z* to multiples of 0.2. All is fine for 0.2, 0.4, 0.8, and 1, but NOT for 0.6 and 1.2 (?!?) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding numbers up or down | Excel Discussion (Misc queries) | |||
How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) | |||
If statement w/ rounding but not all numbers | Excel Worksheet Functions | |||
Rounding off numbers in Excel 2003 | Excel Worksheet Functions | |||
Date & Time | New Users to Excel |