Simple examples with IF function, nested IF function explanation in LibreOffice Calc. This would help you to understand the basics.| libreofficehelp.com