Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |