Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

OpenOffice Calc User Guide
Previous Page Home Next Page

Functions available in Calc

Table 9: Functions available in Calc

Function Category

Standard

Addins

Total

Mathematical

54

8

62

Financial

22

37

59

Statistical

77

0

77

Date and Time

17

13

30

Logical

6

0

6

Informational

16

2

18

Database

12

0

12

Array

14

0

14

Spreadsheet

20

0

20

Text

27

1

28

Total

265

61

326

Calc provides all of the commonly used functions found in modern spreadsheet applications. This appendix is offered to acquaint users with the available functions.Since many of Calc’s functions require veryspecific and carefully calculated input arguments, these descriptions should not be considered complete references for each function. More detailed explanations of the features and requirements of Calc’s functions can be found in the OpenOffice.org help system.

Over 250 standard functions are available in Calc, with many more available through its AddInfeature, which is briefly explained in the last section of this Appendix, “Add-in functionsâ€on page 61. The following tables list Calc’s functions organized in eleven functional categories. Throughout the lists below, any function marked with an asterisk (*) is only available if the Analysis AddIn is installed.



Note

Some of the descriptions in this appendix define limitations on the number of values or arguments that can be passed to the function. Specifically, functions that refer to the following arguments may lead to confusion.

  • Number_1; number_2;... number_30

  • Number 1 to 30

  • a list of up to 30 numbers

There is a significant difference between a list of numbers (or integers) and the number of arguments a function will accept. For, example the SUM function will only accept a maximum of 30 arguments. This limit does NOT mean that you can only sum 30 numbers, but that you can only pass 30 separate arguments to the function.

Arguments are values separated by semi-colons, and can include ranges which often refer to multiple values. Therefore one argument can refer to several values, and a function that limits input to 30 arguments, may in fact accept more then 30 separate numerical values.

This appendix attempts to clarify this situation by using the term arguments, rather than any of the aforementioned phrases. Unfortunately the OOo online help is somewhat vague regarding this matter.



Note

Functions whose names end with _ADD are provided for compatibility with Microsoft Excel functions. They return the same results as the corresponding functions in Excel (without the suffix), which though they may be correct, are not based on international standards. The _ADD functions are only available if the Analysis AddIn is installed.

OpenOffice Calc User Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire