Calc Guide

mode is set to 0, and both the number and the significance are
negative numbers, then the result of either function is rounded up; if it
is set to 1, and both the number and the significance are negative
numbers, then the results are rounded down. In other words, if the
number is -11 and the significance is -5, then the result is -10 when the
mode is set to 0, but -15 when set to 1.
However, if you are exchanging spreadsheets between Calc and MS
Excel, remember that the mode argument is not supported by Excel. If
you want the answers to be consistent between the two spreadsheets,
set the mode in Calc to -1.
A function somewhat similar to CEILING and FLOOR is MROUND. Like
CEILING AND FLOOR, MROUND requires two arguments, although,
somewhat confusingly, the second one is called multiple rather than
significance, even though the two are identical. The difference
between MROUND and CEILING and FLOOR is that MROUND rounds
up or down using symmetric arithmetic rounding. For example, if the
number is 77 and the multiple is 5, then MROUND gives a result of 75.
However, if the multiple is changed to 7, then MROUND's result
becomes 77.
Once you become familiar with Calc’s long, undifferentiated list of
functions, you can start to decide which is most useful for your
purposes.
However, one last point is worth mentioning: If you are working with
more than two decimal places, don't be surprised if you don’t see the
same number of decimal places on the spreadsheet as you do on the
function wizard. If you don’t, the reason is that Tools > Options >
OpenOffice.org Calc > Calculate > Decimal Places defaults to 2.
Change the number of decimal places, and, if necessary, uncheck the
Precision as shown box on the same page, and the spreadsheet will
display as expected.
Using regular expressions in functions
A number of functions in Calc allow the use of regular expressions:
SUMIF, COUNTIF, MATCH, SEARCH, LOOKUP, HLOOKUP, VLOOKUP,
DCOUNT, DCOUNTA, DSUM, DPRODUCT, DMAX, DMIN, DAVERAGE,
DSTDEV, DSTDEVP, DVAR, DVARP, DGET.
Whether or not regular expressions are used is selected on the Tools >
Options > OpenOffice.org Calc > Calculate dialog.
Chapter 7 Using Formulas and Functions 215