Open Office Excel

< Documentation‎ How Tos
< Previous SectionNext Section >
  • If

Official Apache OpenOffice download page. Join the OpenOffice revolution, the free office productivity suite with over 310 million trusted downloads. It's not only Microsoft that offers a full featured application pack for your Office works, but you can enjoy more programs offering nearly the same features and for free. We can enjoy totally free and 100% compatible, so you will not have to pay for features you can have for.

< Previous PageNext Page >

  • 1IF


Returns one of two values, depending on a test condition.


IF(test; value1; value2)where:

test is or refers to a logical value or expression that returns a logical value (TRUE or FALSE).
value1 is the value that is returned by the function if test yields TRUE.
value2 is the value that is returned by the function if test yields FALSE.

If value2 is omitted it is assumed to be FALSE; if value1 is also omitted it is assumed to be TRUE.


IF(A1>5; 100; 'too small')

returns the number 100 if A1 is greater than 5, and the text 'too small' otherwise.

IF(1>2; 'nonsense')

returns FALSE - because value2 has been omitted and 1 is not greater than 2.

Open Office Excel Formulas


Open Office Excel
returns TRUE - because both value1 and value2 have been omitted and 2 is more than 1.

IF(1=2; 1/0; SQRT(4))

returns 2, the square root of 4. IF() only calculates the value chosen - in this case 1/0 would give a #DIV/0! error, but is not calculated.

See Also

Open Document Free Download

If you are looking for OpenOffice SpreadSheets, you have come to the right place. Burp suite introduction. We explain what OpenOffice SpreadSheets is and point you to the official download.

What is OpenOffice SpreadSheets?

OpenOffice SpreadSheets is an application included in the OpenOffice Suite from The Apache Software Organization. The Suite also includes Writer, which is the word processing application of the software; Impress, the presentation application; Draw, a drawing utility; Math, an equation editor; and Base, a database management system for desktops.
The spreadsheets application of the software suite is known as Calc or OpenOffice Calc. A Calc spreadsheet is composed of API (Application Programming Interface) objects that allow for organized data inputs. API objects that can be utilized in a Calc spreadsheet include the following: Columns, Rows, SheetCell, SheetCellRange, and SheetShell Range Collections. Generally, a spreadsheet consists of a SheetCellRange and a series of sub-ranges.
Columns can be widened to accommodate length of data inputted, allowing for accurate display of complete data. Data alignment can be centered, left, right or justified; the options for which are all provided on the toolbar. Cells can likewise be merged, with the Merge Cells option provided in the Formatting toolbar icon.
The software allows for data importation created with other spreadsheet programs such as Microsoft Excel. OpenOffice SpreadSheets is a free application that can be downloaded from the Apache website.

Download OpenOffice SpreadSheets from the developer does not provide software hosting. We send you directly to the developer's site, to make sure you download the latest, original version of the program.

File types supported by OpenOffice SpreadSheets

Our users primarily use OpenOffice SpreadSheets to open these file types:

Openoffice Excel Download

About file types supported by OpenOffice SpreadSheets

Open Office Excel App aims to be the go-to resource for file type- and related software information. We spend countless hours researching various file formats and software that can open, convert, create or otherwise work with those files.

If you have additional information about which types of files OpenOffice SpreadSheets can process, please do get in touch - we would love hearing from you.

Comments are closed.