Re: Round Function Philosophy

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In such acct. cases, rounding is generally an option needed to please the
calculator's eye of who shall check and accept it....

*i'm concerned about the word "to be employed". ***
Philosophically relevant among human and computer sense of performance...to
acclaim a considerable precision results...unless newly accepted
experimentations arises that replaces the universally known tolerances on
every feld of study and implementation - separately derived from human and
computer results.

regards,
driller
--
*****
birds of the same feather flock together..



"Meebers" wrote:

Conversly, rounding can make you a penny off....eventually.

"Peo Sjoblom" <terre08@xxxxxxxx> wrote in message
news:eNwdVvPuHHA.3816@xxxxxxxxxxxxxxxxxxxxxxx
If you use Excel in accounting for reconciliation of bank statements etc
you need to round or else you will be a penny off eventually.


--
Regards,

Peo Sjoblom


"Rick Rothstein (MVP - VB)" <rickNOSPAMnews@xxxxxxxxxxxxxxxxx> wrote in
message news:%23STZ5oPuHHA.5036@xxxxxxxxxxxxxxxxxxxxxxx
I teach Excel classes at a community college, and have a very good
understanding of the Round fuction, except for one statement I heard
another instructor make one time which has left me curious. I heard
him say that you should always use the Round fuction in any formula
where any multiplication or division is taking place. I think that's
quite a broad statement, and if true, the spreadsheet world would be
covered with Round functions. But it does beg the question...is there
something to what he said? Is there a broad rule about when a Round
function needs to be employed, and perhaps when it should NOT be
employed?

My question back to this instructor would have been... Round to what
number of decimal places? For example, how many decimal places should I
round PI to before calculating the area of a circle? The only time I can
think off the top of my head of where rounding might be something to
consider is in laboratory experiments where measurement precision, and
its effect on calculated results (error propagation), could be a
consideration.

Rick





.

Relevant Pages

  • Re: XQ and ->Qpi bug on large X
    ... you shouldn't be rounding to only two digits ... I am trying to make a similar point here about rounding; ... and round it, ... prior to using the input values in calculations. ...
    (comp.sys.hp48)
  • Re: My Completed RATECRYPT() function included below
    ... I was interested because most rounding functions do not round in an unbiased manner. ... I have seen various reports of clipper rounding problems but there are many different rounding methods and clipper chose a common one. ... The gaussian method (an unbiased estimator) gives the same answer you would get using a standard c compiler and printed with printf. ...
    (comp.lang.clipper)
  • Re: Rounding question
    ... Very many thanks for your help, Joe. ... It would be nice to get Excel to default to rounding, however I'll take one step at a time... ... you probably want to use ROUND whenever the result should be dollars and cents or any other specific number of decimal places. ... And although the number formats are set to 2 dp, this evidently only applies to the display! ...
    (microsoft.public.excel)
  • Re: XQ and ->Qpi bug on large X
    ... plot of all specific values resembling a "normal distribution" ... we should round each value ... which fails if we start computing "mean square" ... the moment we begin rounding data, we make the data less reliable ...
    (comp.sys.hp48)
  • Re: Mike W. Corner
    ... tender and will round up in half-a-heartbeat, you can spin them out. ... Rounding up is one of your two primary defenses against a broach. ... Having a plan sure helps. ...
    (rec.motorcycles.dirt)