DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DAVERAGE, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARPĭate & Time functions The Date & Time functions are used to manipulate dates and times.

COMPLEX, IMABS, IMAGINARY, IMPOWER, IMARGUMENT, IMCOS, IMCOSH, IMCOT, IMCSC, IMCSCH, IMDIV, IMEXP, IMCONJUGATE, IMLN, IMLOG10, IMLOG2, IMPRODUCT, IMREAL, IMSEC, IMSECH, IMSIN, IMSINH, IMSQRT, IMSUB, IMSUM, IMTANĭatabase functions The Database functions are used to extract information from Calc data tables, where data is organised in rows.

FREQUENCY, GROWTH, LINEST, LOGEST, MDETERM, MINVERSE, MMULT, MUNIT, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TRANSPOSE, TRENDĬomplex Number functions The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.

see a list of functions in alphabetic order.Īrray functions The Array functions operate on and return entire tables of data.

select a function category, to find a one line description of each function and explanatory notes on the category, or.navigate directly to the functions from this page, or.The aim is to have more detail and support than the Help pages for other major spreadsheets. These pages are a complete rewrite of the Function Help for Calc, with links to other relevant topics.

Formulas en openoffice calc