OpenOffice.org Calc 3. Mathematical Functions

  1. ABS(number) Function
  2. ACOS(number) Function
  3. ACOSH(number) Function
  4. ACOT(number) Function
  5. ACOTH(number) Function
  6. ASIN(number) Function
  7. ASINH(number) Function
  8. ATAN(number) Function
  9. ATAN2(number_x; number_y) Function
  10. ATANH(number) Function
  11. CEILING(Number; Significance; Mode) Function
  12. COMBIN(number_1; number_2) Function
  13. COMBINA(number_1; number_2) Function
  14. CONVERT(value; text1; text2) Function
  15. COS(Number) Function
  16. COSH(number) Function
  17. COT(number) Function
  18. COTH(number) Function
  19. COUNTBLANK(range) Function
  20. COUNTIF(range; criteria) Function
  21. DEGREES(number) Function
  22. EVEN(number) Function
  23. EXP(number) Function
  24. FACT(number) Function
  25. FLOOR(Number; Significance; Mode) Function
  26. GCD(Integer 1; Integer2; ...) Function
  27. GCD_ADD(number 1; number2; ...) Function
  28. INT(number) Function
  29. ISEVEN(value) Function
  30. ISODD(value) Function
  31. LCM(Integer 1; Integer 2; ...) Function
  32. LCM_ADD(number1; number2; ...) Function
  33. LN(number) Function
  34. LOG(Number; Base) Function
  35. LOG10(number) Function
  36. MOD(Dividend; Divisor) Function
  37. MROUND(Number; Multiple) Function
  38. MULTINOMIAL(number1; number2; ...) Function
  39. ODD(number) Function
  40. PI() Function
  41. POWER(Base; Exponent) Function
  42. PRODUCT(number 1; number 2; ...) Function
  43. QUOTIENT(Numerator; Denominator) Function
  44. RADIANS(Number) Function
  45. RAND() Function
  46. RANDBETWEEN(Bottom; Top) Function
  47. ROUND(number; count) Funcion
  48. ROUNDDOWN(number; count) Function
  49. ROUNDUP(number; count) Function
  50. SERIESSUM(X; N; M; Coefficients) Function
  51. SIGN(number) Function
  52. SIN(number) Function
  53. SINH(number) Function
  54. SQRT(number) Function
  55. SQRTPI(number) Function
  56. SUBTOTAL(Function; Range) Function
  57. SUM(Number1; Number2; ...) Function
  58. SUMIF(range; criteria; sum_range) Function
  59. SUMSQ(number 1; number2; ...) Function
  60. TAN(number) Function
  61. TANH(number) Function
  62. TRUNC(number; count) Function

 

Back to the list of functions