How to use the IF function with the AND function in LibreOffice Calc
Vložit
- čas přidán 3. 09. 2022
- This is a LibreOffice Calc tutorial covering, how to use the IF function with the AND function. The tutor starts off by explaining that a basic IF function only has one test or condition, but if the AND function is added multiple tests are available. The tutor uses two examples. The AND function tests must all be true for the true part of the IF statement to work. This is a LibreOffice Calc tutorial. How to use the IF function with the AND function in LibreOffice Calc.
#calc
#libreoffice
If you want to support me, check this out: / itseasy
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
Use an IF function with the And function in LibreOffice Calc or Excel. Check out courses at www.itseasy.co.uk
Love this, thanks
You are so welcome!
Thanks for a great video, and for taking the time and effort of sharing Your knowledge.
That said I will add my ""caveat"" that I add to very many tutorials/instructive videos.
I personally believe that this video (like so many) could have been even better if it wasn't created with such a "High resolution". Rather let the "GUI" and the other "relevant elements" take up the majority of the "screen", and just "omit" "the rest". The easiest way to do this is to record it using the "lowest screen resolution possible", which automatically will "force"/incentivise You" to .
I say this as a person with "limited sight" who often find useful videos very hard to "use", simply because they were recorded on a large screen with everything in "high resolution". Which results in that the "actually interesting parts", regardless of it's "text input", "GUI interaction" or some other "interaction on screen", are unfortunately almost unintelligible. Especially if viewed at a screen that is smaller AND/OR lower resolution than the screen size and resolution used when recording the video.
Now not to criticise this video in particular, but just to clarify what I mean: I believe that this video would have been even more useful to more people if it had been demonstrated on a spread sheet with less "empty cells", and even omit most of the unused ones. And instead letting "everything else" be comparatively bigger. The fact that this has the size and look of an actual professional spreadsheet doesn't really add anything to the merits of this video.
Please don't interpret my criticism as me being ungrateful, it's just an attempt at giving feedback that I believe might make Your great videos even better and more useful.
Best regards.
I have sight issues myself
really useful
Glad you think so!
Interesting stuff
thanks
Great example thanks
You are welcome!
Love it thanks
No problem