This video explains how to use an IF function in LibreOffice Calc

How to use the IF function in Libre Office Calc. IF Function. The tutor uses a basic IF function to work out a bonus, overtime hours and budget status. The tutor starts off by using cell references in an IF function but then uses named ranges. The tutor explains how to use text within and IF function and how to use named ranges. An IF function requires a test, what to do if it’s true and what to do if it’s false. This is a Libre Office Calc tutorial covering basic IF functions, Sum Function and named Ranges.
#libreoffice
#calc
If you want to support me, check this out: / itseasy
Playlists for this channel:
Access: • Unleash the POWER of S...
Excel: • Link web based data in...
Word: • How to use Microsoft W...
Visio: • How to create a basic ...
Project: • How to use Baselines a...
PowerPoint: • Zoom feature in Micros...
Publisher: • How to set or create B...
OneNote: • OneNote Overview, link...
Office 365: • Video
#itseasytraining
Classroom based courses can be arranged at www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at itseasytraining.teachable.com/
Udemy Courses www.udemy.com/user/stephen-sa...
Training Guide Books
Excel for New Managers
www.amazon.co.uk/Excel-New-Ma...
Microsoft Project Overview www.amazon.co.uk/Microsoft-Pr...
Microsoft Visio Basic www.amazon.co.uk/Microsoft-Vi...
Very cheap E_books are here:
Excel For New Managers payhip.com/b/IE4x
Microsoft Project Overview payhip.com/b/wY0m
Microsoft Visio Basics payhip.com/b/5XeV
Microsoft Access Introduction payhip.com/b/ynSL
A PowerPoint Overview payhip.com/b/YkQv

[@ITsEasyTraining1st]

How to use an IF Function in Libre Office Calc. LibreOffice is a free tool. Check out courses at www.itseasy.co.uk

[@jagdeepsinghthakur8871]

Thank you sir

[@ITsEasyTraining1st]

You are welcome

[@Albertbullterrier]

Love it

[@ITsEasyTraining1st]

Thanks

[@LTS720]

Is it possible to create a function that has 3 different text options rather than just true or false? I need a function that can display three different texts depending on a cell's value range. Thanks.

[@ITsEasyTraining1st]

You can create a nested IF. if( A1=1,10%,if(A1=2,20%,if(a1=3,30%,0))) if you use text tit would need to be in quotes

[@EasyMSAccess]

Very good

[@ITsEasyTraining1st]

Thanks

[@EasyMSProject]

very good

[@ITsEasyTraining1st]

Thanks

[@jagdeepsinghthakur8871]

Please sir show me clear calc window.. Please do zoom

[@ITsEasyTraining1st]

Will do

[@grannysaxton9568]

Cool

[@ITsEasyTraining1st]

thanks

[@EasyGoogle]

Love it

[@ITsEasyTraining1st]

Thanks