In this tutorial, you will learn the basics of powerful IF, nested IF, AND, OR conditions in LibreOffice Calc.
Table of Contents
Summary
The IF Function is a logical test at your cell which returns TRUE when a condition is met; otherwise, it returns FALSE. Hence, you can use it to return any different value in the target cell based on your test. You can also extend your test using nested-IF conditions clubbed with AND, OR operators.
Purpose
Logical test for a condition in any given cell.
Return Value
Returns your values based on TRUE or FALSE. If your return value is omitted, return the string “TRUE”/”FALSE”.
Syntax
=IF(Test, value_when_true,value_when_false)
Examples
In the example below, when the temperature crosses 40 degrees C, return Hot in the corresponding cell otherwise, return Normal.
=IF(A2>40,"Hot","Normal")
The above example depicts a simple IF condition. Let’s see how you can do nested IF with AND condition.
To make it more complex, let’s add more conditions. When the temperature is below 15 deg C it is Cold; when between 15 and 45 deg C – Normal; Otherwise return Hot in the corresponding cell.
=IF(A2<15,"Cold",IF(AND(A2>=15,A2<45),"Normal","Hot"))
The above example contains two IF statements with a nested IF. The FALSE condition of the outer IF contains another IF statement – i.g. when the first condition is False, we check another IF for further condition.
The AND function returns TRUE when both conditions are true.
Usage Notes
- The maximum number of levels in nested IF is 42. (ref this).
So, this is how you can use the IF function in Calc. Drop a note below if you have any questions.