The IF function is a powerful in-cell function in LibreOffice or OpenOffice Calc.
In this tutorial, you will learn the basics of powerful IF, nested IF, AND, OR conditions in LibreOffice Calc.
This guide would help you to find out whether a cell contains specific text. This can be extended to multiple cells and give you flexibility on your calc operation.
This tutorial will explain on how to convert a list of “text which represents numbers” to numbers.
This tutorial will explain various ways the COUNTIF function in LibreOffice Calc can be used to count strings, numbers from a cell, range, rows, columns, etc.
This tutorial explains the basics of SUMIF and SUMIFS functions in LibreOffice Calc.
In this tutorial, you will learn about Date and Time formats and how they are represented in LibreOffice Calc.
This beginner’s guide explains the concepts of relative, absolute, and mixed reference in LibreOffice Calc.
There are many ways you can split cell content into multiple columns in a LibreOffice Calc sheet. Here are some of them.