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 (?!?)
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 (?!?)
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 (?!?)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks