IF Function in LibreOffice Calc – Basics and Examples
The IF function is a powerful in-cell function in LibreOffice or OpenOffice Calc.
Quick Tutorials, Solutions and to the point.
Check If Cell Contains Specific Text 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.
Convert Text to Number in LibreOffice Calc
This tutorial will explain on how to convert a list of “text which represents numbers” to numbers.
Count Cells with Strings and Numbers Using COUNTIF in LibreOffice Calc
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.
SUMIF and SUMIFS Function with Examples in LibreOffice Calc
This tutorial explains the basics of SUMIF and SUMIFS functions in LibreOffice Calc.
Date and Time Formats in LibreOffice Calc
In this tutorial, you will learn about Date and Time formats and how they are represented in LibreOffice Calc.
Basics of Relative, Absolute and Mixed Reference in Calc
This beginner’s guide explains the concepts of relative, absolute, and mixed reference in LibreOffice Calc.
Split Content of Cell into Multiple Columns 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.
LibreOffice Calc, Writer, Impress: Supported File Formats
This page outlines the file formats supported by the LibreOffice Calc spreadsheet and other programs.