If Libreoffice

Posted onby admin

What is LibreOffice?

Do more – easily, quickly

LibreOffice is a powerful and free office suite, a successor to OpenOffice(.org), used by millions of people around the world. Its clean interface and feature-rich tools help you unleash your creativity and enhance your productivity. LibreOffice includes several applications that make it the most versatile Free and Open Source office suite on the market: Writer (word processing), Calc (spreadsheets), Impress (presentations), Draw (vector graphics and flowcharts), Base (databases), and Math (formula editing).

Great-looking, well-structured documents

  1. These free LibreOffice templates are easy to download and print. Each template is available in LibreOffice format: just download one, open it in LibreOffice, edit, and print. Also available: more free printables including templates for OpenOffice, printable signs, and business form templates.
  2. From Wikipedia, the free encyclopedia LibreOffice / ˈliːbrə / is a free and open-source office productivity software suite, a project of The Document Foundation (TDF). It was forked in 2010 from OpenOffice.org, which was an open-sourced version of the earlier StarOffice.

Your documents will look professional and clean, regardless of their purpose: a letter, a master thesis, a brochure, financial reports, marketing presentations, technical drawings and diagrams. LibreOffice makes your work look great while you focus on the content, thanks to its powerful styles system and structuring tools.

Use documents of all kinds

LibreOffice is compatible with a wide range of document formats such as Microsoft® Word (.doc, .docx), Excel (.xls, .xlsx), PowerPoint (.ppt, .pptx) and Publisher. But LibreOffice goes much further with its native support for a modern and open standard, the Open Document Format (ODF). With LibreOffice, you have maximum control over your data and content – and you can export your work in many different formats including PDF.

2021.05.01 English dictionaries for OpenOffice/LibreOffice 4.0+ 4.0 Linux, Windows, macOS LGPL. MAGP 2021-05-01 Updated the Dictionaries: - British (Marco A.G.Pinto). British has 931 new words(1) (2021-05-01). (1) Added tons of plurals and possessives. Download; 2021.04.01 English dictionaries for OpenOffice/LibreOffice 4.0+ 4.0 Linux.


Get more features with extensions

Beyond the many features shipped by default, LibreOffice is easily extensible through its powerful extensions mechanisms. Get even more features and document templates on our dedicated websites.

Free as in Freedom, now and forever

LibreOffice is Free and Open Source Software, available for everyone to use, share and modify, and produced by a worldwide community of hundreds of developers. Our software is tested and used daily by a large and devoted user community – we're open to new talent and new ideas, so get involved and influence its future.

If Libreoffice

Built on a strong heritage

LibreOffice is a successor to OpenOffice.org (commonly known as OpenOffice), which in turn was based on StarOffice. Many years of development have gone into the software, and it has been used in its various incarnations by millions. Today, LibreOffice is by far the most active continuation of the OpenOffice.org codebase, with releases every six months and hundreds of contributors. Also, LibreOffice uses libraries from the Document Liberation Project, handing control back to content creators.

LibreOffice for your business

You can download and use LibreOffice for free, but bear in mind that it doesn't include technical support or other value-added services. If you want to deploy LibreOffice in a business, we strongly recommend sourcing a LibreOffice-based solution from one of our ecosystem partners.

More information

· Download LibreOffice in your language and discover how it can boost your creativity on a day-to-day basis
· Discover how LibreOffice fares vs. Microsoft® Office
· LibreOffice is available in many, many languages. Find out about yours!
· Check out our release notes

The IF function is one of the most popular functions in Calc and other spreadsheet applications. IF performs a logical test and return one value for a TRUE result, and another for a FALSE result. In its simplest form, the IF function says:

IF(Something is True, then return value1, otherwise return value2)

Let's see a typical example of the IF function. A teacher uses a spreadsheet to calculate the average (final) score of his students.

In the Pass/Faill column he wants to display a 'Pass' text if the final score is greater or equal to 70. Using the IF function the formula is


After the function is filled the 'Pass' or 'Fail' result will be displayed.

Then you can use autofill to fill the remaining cells.

Libreoffice If Contains

IF Syntax

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.

Libreoffice Calc If Blank

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.



Libreoffice Calc If Statement

If Libreoffice

If Statement In Libreoffice

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

Comparative operators

Comparative operators are found in formulas that use the IF function and return either a true or false answer.

=EqualA1 = B1
>Greater thanA1 > B1
<Less thanA1 < B1
>=Greater or Equal thanA1 >= B1
<=Less or Equal thanA1 <= B1
<>InequalityA1 <> B1