Libreoffice If

admin 11/23/2021

LibreOffice is een krachtig officepakket; zijn duidelijke interface en krachtige functies bevorderen uw creativiteit en productiviteit. LibreOffice bundelt verschillende toepassingen, wat het het krachtigste vrije, open source officepakket maakt.

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

Nsqf it level 1 unit 2 electronic spreadsheet (advanced ) part 3. We would like to show you a description here but the site won’t allow us. This guide is intended for LibreOffice Calc users, who wants to use conditional for-matting in their work. All name of menu, toolbars, tooltips, dialogue, button and any other elements of GUI are from LibreOffice Calc 6.0.3. When I wrote this guide, I found some bugs in GUI and in execution of conditional formatting in LibreOffice Calc 6.0.3.


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

Then you can use autofill to fill the remaining cells.

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.

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')

Libreoffice Calc If Statement

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


DownloadLibreoffice office suite

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

Comparative operators

Libreoffice If Statement

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

Libreoffice Official Site

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