Stop Rounding Currency

[GS]

joeu2004 was thinking very hard :

Not surprisingly, you seem to have misunderstood my meaning.

I meant: yes, I do not think you know how numbers work [and] when
these functions need to be applied.

I gathered that! I just saw no point in creating a confrontation...

So it would seem that we have been in violent agreement.

But I believe that is clearly not true.

You're wrong there!

Previously, you wrote....

"Since the 2 cells containing the taxes have been processed using the
ROUND() function, it's not necessary to use the function with
SUM()." [Fri, 25 Feb 2011 19:23:43 -0500]

And....

"I do, however, still stand that if all the values in the
SUM() have been calculated with the ROUND() function then using
ROUND() in SUM() is pointless." [26 Feb 2011 02:04:30 -0500]

And....

"IF the values were calculations (as with the OP's example) then using
ROUND() with SUM() isn't necessary".

Those are all very general statements about calculations.

They were made in context to the OP's scenario ONLY. You constued them
to be general statements all along. I was hoping you picked that up by
my demonstrating with your example scenarios...

A "calculation" is an "expression", and Mondou's example involved non-
integers, and Mondou intended the results to have a specific
precision.


You wrote on 26 Feb 2011 11:57:11 -0500:

I agreed that you were correct __by_coincidence__ because of the
specific numbers used in Mondou's example.

But I quickly stated that I did not agree with you __in_general__, and
I demonstrated your fallacy using Mondou's scenario with different
numbers.

There was no falacy in my statement because it was not a 'general
statement'. Also, I demonstrated my point by doing the same thing with
your substitute scenario. My approach worked perfectly there as it did
with the OP's numbers. Read it again to confirm...

It was YOU who determined I was wrong based your (erroneous)
presumption I was making a 'general statement'.

(After that, I moved on to other scenarios because I felt they
demonstrated the same __concept__ more readily.)

If you have the experience that you claim, you know that we do not
write solutions for specific numbers. Instead, algorithms should be
correct for the full range of expected numbers.
Agreed...


ROUND(SUM(A1:C1),2) is needed in Mondou's scenario because with other
numbers, the result of SUM(A1:C1) alone will not exactly match the
displayed value (showing only 2 decimal places), and that might trip
up Mondou later on.

I really cannot say that any more clearly.

You already stated this wasn't necessary in Mondou's scenario. -Leads
me to think you're more confused about how numbers work than you
believe I am. Make up your mind! You haven't revealed any I didn't
already know, whether you choose to believe that or not. Taking my
statement out of context doesn't make it wrong as stated.

I guess we'll just continue to violently agree...