Choose from 356 OpenOffice templates, in the native .ODT and .ODS formats, that you can download, edit, and print for free. Choose from templates for business or personal use, including fax cover sheets, letterhead, to-do lists, and more.
OpenOffice Calc User Guide; Previous Page: Home: Next Page: Secondary y-axes. You may want to have a chart or graph with more than one y-axis. This can be very useful.
Here are the 10 most popular Open Office templates:
Copyright © 2013-2021 by Savetz Publishing, Inc. Contact us. Privacy Policy.
Modul Open Office Calc 1. 2011 MODUL APLIKASI PENGOLAH ANGKA (OPEN OFFICE CALC) DASAR OpenOffice.org Calc mempunyai kegunaan yang sama dengan Microsoft Excel dimana OpenOffice.org Calc berguna untuk membuat file spreadsheet. You can prevent OpenOffice from printing the check box by double-clicking it when the 'Design Mode On/Off' button is pressed and then selecting 'No' from the 'Printable' drop-down box. You can change the background color of the check box by opening its Properties window and then selecting a color from the 'Background color' drop-down box. Open the spreadsheet in OpenOffice Calc. Use this method if you have OpenOffice Calc on your PC or Mac. 2 Click the File menu. It’s at the top-left corner of the screen.
Subscribe to the Free Printable newsletter. (No spam, ever!)
These free OpenOffice templates are easy to download and print. Each template is available in OpenOffice format: just download one, open it in OpenOffice, edit, and print.
Also available: more free printables includingLibreOffice Templates.
Home
Categories
Search All Printables
If you don't see an OpenOffice Template design or category that you want, please take a moment to let us know what you are looking for.We're always adding new printables, and would love to hear your suggestions. What are we missing?
| < Previous Section | Next Section > |
| < Previous Page | Next Page > |
List of Calc Mathematical functions
Openoffice Calc Online
| Trigonometric | |
| COS | Returns the cosine of an angle. |
| SIN | Returns the sine of an angle. |
| TAN | Returns the tangent of an angle. |
| COT | Returns the cotangent of an angle. |
| ACOS | Returns the inverse cosine of a number. |
| ACOT | Returns the inverse cotangent of a number. |
| ASIN | Returns the inverse sine of a number. |
| ATAN | Returns the inverse tangent of a number. |
| ATAN2 | Returns the inverse tangent for specified x and y coordinates. |
| DEGREES | Converts radians into degrees. |
| RADIANS | Converts degrees into radians. |
| PI | Returns the value of PI. |
| Hyperbolic | |
| COSH | Returns the hyperbolic cosine of an angle. |
| SINH | Returns the hyperbolic sine of an angle. |
| TANH | Returns the hyperbolic tangent of an angle. |
| COTH | Returns the hyperbolic cotangent of a given number (angle). |
| ACOSH | Returns the inverse hyperbolic cosine of a number. |
| ACOTH | Returns the inverse hyperbolic cotangent of the given number. |
| ASINH | Returns the inverse hyperbolic sine of a number. |
| ATANH | Returns the inverse hyperbolic tangent of a number. |
| Rounding and remainders | |
| TRUNC | Truncates a number by removing decimal places. |
| ROUND | Rounds a number to a certain precision. |
| ROUNDDOWN | Rounds a number down, toward zero, to a certain precision. |
| ROUNDUP | Rounds a number up, away from zero, to a certain precision. |
| CEILING | Returns a number rounded up to a multiple of another number. |
| FLOOR | Rounds a number down to the nearest multiple of another number. |
| EVEN | Rounds a number to the next even integer away from zero. |
| ODD | Rounds a number up to the next highest odd integer. |
| MROUND | Returns a number rounded to the nearest multiple of another number. |
| INT | Rounds a number down to the nearest integer. |
| QUOTIENT | Returns the integer result of a division operation. |
| MOD | Returns the remainder when one integer is divided by another. |
| Logarithm / powers | |
| EXP | Returns e raised to the power of a number. |
| POWER | Returns a number raised to a power. |
| LOG | Returns the natural logarithm of a number. |
| LN | Returns the logarithm of a number to the specified base. |
| LOG10 | Returns the base-10 logarithm of a number. |
| Bessel functions | |
| BESSELI | Calculates the modified Bessel function of the first kind. |
| BESSELJ | Calculates the Bessel function of the first kind. |
| BESSELK | Calculates the modified Bessel function of the second kind. |
| BESSELY | Calculates the Bessel function of the second kind (the Neumann or Weber function). |
| Miscellaneous | |
| ABS | Returns the absolute value of a number. |
| COMBIN | Returns the number of combinations of a subset of items. |
| COMBINA | Returns the number of ordered combinations of a subset of items. |
| CONVERT | Converts between legacy European currencies and Euros. |
| CONVERT_ADD | Converts a number from one measurement system to another. |
| COUNTBLANK | Returns the number of empty cells. |
| COUNTIF | Counts the number of cells in a range that meet a specified condition. |
| DELTA | Returns 1 if two numbers are equal, and 0 otherwise. |
| ERF | Calculates the error function (Gauss error function). |
| ERFC | Calculates the complementary error function (complementary Gauss error function). |
| FACT | Returns the factorial of a number, n!. |
| FACTDOUBLE | Returns the double factorial of a number, n!!. |
| GCD | Returns the greatest common divisor of two or more integers. |
| GCD_ADD | Returns the greatest common divisor of a list of numbers. |
| GESTEP | Returns 1 if a number is greater than or equal to a step number, or 0 otherwise. |
| ISEVEN | Returns TRUE if the value is an even number. |
| ISODD | Returns TRUE if the value is an odd number. |
| LCM | Returns the least common multiple of one or more integers. |
| LCM_ADD | Returns the lowest common multiple of a list of numbers. |
| MULTINOMIAL | Returns the factorial of the sum divided by the product of the factorials. |
| PRODUCT | Multiplies all the numbers given as arguments and returns the product. |
| RAND | Returns a random number between 0 and 1. |
| RANDBETWEEN | Returns an integer random number in a specified range. |
| SERIESSUM | Sums the first terms of a power series. |
| SIGN | Returns the sign of a number. |
| SQRT | Returns the positive square root of a number. |
| SQRTPI | Returns the square root of (PI times a number). |
| SUBTOTAL | Returns SUM, AVERAGE, STDDEV, etc. results for filtered data. |
| SUM | Sums the contents of cells. |
| SUMIF | Conditionally sums the contents of cells in a range. |
| SUMSQ | Returns the sum of the squares of numbers. |
Download hdmi to rca adapter for tv for mac os xoikos.
Open Office Excel Free
- Functions listed alphabetically,