Re: Round Function Philosophy

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

I know, that is why I do it very carefully


--
Regards,

Peo Sjoblom



"Meebers" <justme@xxxxxxxxxxxx> wrote in message
news:eEajM2PuHHA.1052@xxxxxxxxxxxxxxxxxxxxxxx
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: Combo Box - HELP
    ... > I always need to round to the nearest 1/8th. ... you can get the same result using built in functions ... >> Regards, ... >> Peo Sjoblom ...
    (microsoft.public.excel.misc)
  • Re: Round Function Philosophy
    ... you need to round or else you will be a penny off eventually. ... covered with Round functions. ... round PI to before calculating the area of a circle? ... think off the top of my head of where rounding might be something to ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Time sheet set up specifically
    ... Peo Sjoblom ... (No private emails please, for everyone's ... benefit keep the discussion in the newsgroup/forum) ... > 35 minutes should round up to 45 minutes ...
    (microsoft.public.excel.newusers)
  • Re: Combo Box - HELP
    ... I always need to round to the nearest 1/8th. ... Is there a built in function that can do the same thing? ... "Peo Sjoblom" wrote: ... >> The other issue I have is that I used the MRound function in the file and ...
    (microsoft.public.excel.misc)
  • Re: How do I convert decimal values to hours & minutes in Excel 20
    ... The formulas I provided round to the nearest ... Peo Sjoblom ... the latter does the rounding first on the decimals and then converts it ...
    (microsoft.public.excel.misc)