How to use the IF function with the AND function in LibreOffice Calc

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

Courses are available through Microsoft Teams, Online and Face to face in the UK

Training Guide Books
Excel for New Managers
Very cheap E_books are here:

[libreofficetutorials]

Use an IF function with the And function in LibreOffice Calc or Excel. Check out courses at www.itseasy.co.uk

[MisterTIBS]

Thanks. For future reference, or anyone else using OpenOffice Calc instead, pretty much means use semi-colon where you would normally expect to use a comma to separate stuff, e.g. sht")

[onlyeyeno]

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.

[jongrosjean]

Thank you very much. I have been trying to do this for 2 days. It is not in the help menu.