Ross Johnson wrote:
> I agree with Bob. Rounding does NOT give you the "correct" answer. The
> correct answer is the one you had in the first place, even though it
> didn't seem correct on the surface, because if you used 38.8300000 in
> the calculation, you'd get a different answer. But the one you got in
> the first place was "correct", and the one you got when you used
> 38.8300000 was "incorrect". So I'm not sure why you're introducing the
> ROUND function to knowingly give you an incorrect answer.
>
> In any case, the difference between rounded and not rounded is about
> 0.008% -- in my opinion hardly enough to worry about. But you did have
> a concern that you had this tiny difference, in which case, I'm again
> not sure why you would ROUND to give you an answer which is incorrect.
It all depends on what is actually shown on the invoice - 39:50 or
39.83. Usually it's the hr/min, so rounding would be incorrect. And it
may only be a small difference, but someone else may be checking the
figures, and you don't want them coming up with different answers and
then doubting every other calculation you do.
39:50 is actually shown on the invoice. As far as I'm concerned, it
was right the first time. However, it was rejected by the client as
being incorrect by a few cents out.
What can you do.
Matt
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
