Hi,

Format H7 and H11 to have lots of decimal places (30) and you'll see the
answer.

Mike

"Baldbloke" wrote:

Hi

Excel 2003 SP2... can anyone help? Using ROUNDDOWN function, I am getting
two different results from the same data

The spreadsheet I'm using has data entered thus. I can't post the actual
spreadsheet here, but can mail it if anyone's interested!

To replicate the error, enter these as values in the cells as follows:
20.4 in A4; 0.8 in A5, 400in A7, 300 in A8, 4 in A11 and 3 in A12.

Excluding the quotes, enter these formulae: "=A7*A4/A8" in cell D7;
"=D7/A5/5-6" in F7; "ROUNDDOWN (F7,1)" in H7. This will give a result in H7
of 0.7000

Now enter these: "=A11*A4/A12" in D11; "=D11/A5/5-6" in F11; "ROUNDDOWN
(F11,1)" in H11. This will give a result in H11 of 0.8000

The problem is that although the results of the calculations in both columns
D and F return the same result, the ROUNDDOWN function creates two different
results, even though the data referred to in each ROUNDDOWN formula is of the
same values. The result in cell H11 is correct, the result in H7 is not.

The cells are formatted as general.

Any ideas?

Thanks

BB