Rounding functions I
There are almost a dozen available rounding functions available in OOo Calc. We will first look at ROUND(), ROUNDUP() and ROUNDDOWN()
ROUND() is the function that is most commonly used. The arguments to this function are
ROUND(number, numdigits) where
- number The number to be rounded.
- numdigits The number of digits you want the number rounded to.
The example below shows the effect of NUMDIGITS on the final result.
ROUNDUP() and ROUNDDOWN() are similar to BOUND() except the rounding is restrited to a particular direction (up or down) depending on the function that is invoked.
The few examples below show how these two functions produce different results for the same input.
September 13th, 2007 at 8:01 am
Very useful. Many thanks!