Re: mesa & rounding

In <ErqdnfeXC9giY8nbnZ2dnUVZ_s2vnZ2d@xxxxxxxxxxxx>, on 05/23/2007
at 09:57 PM, Dilbert Firestorm <scanb31@xxxxxxxxxx> said:

Hi,

FYI, I use ComputerShare for my DRIP investment.

OK. And what type of rounding do they use? If you know nothing about
rounding, wikepedia has a reasonably good explanation of the most common
methods. I suspect ComputerShare uses the round to even method.
Unfortunately, mesa does not have this as a built in function, but it can
be implemented.

I figured out that the Range display setting wasn't gonna cut it.

how do I use @round?

- start mesa
- press F1
- search for @round
- read documentation
- try it in a test worksheet

Regards,

Steven

--
--------------------------------------------------------------------------------------------
Steven Levine <steve53@xxxxxxxxxxxxxxxxxxx> MR2/ICE 3.00 beta 05 #10183
eCS/Warp/DIY/14.103a_W4 www.scoug.com irc.ca.webbnet.info #scoug (Wed 7pm PST)
--------------------------------------------------------------------------------------------

.

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: rounding a value to nearest 1/2
    ... I need to round it ... this formula is used in the Swiss Monetary rounding system. ... In Switzerland the common rounding is 0.05 CHF ... Rappen coins are the smallest commonly used coins, ...
    (comp.lang.javascript)