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

[@libreofficetutorials9499]

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

[@grannysaxton9568]

Love this, thanks

[@libreofficetutorials9499]

You are so welcome!

[@EasyMicrosoftWord]

Interesting stuff

[@libreofficetutorials9499]

thanks

[@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. =IF(AND(B2="a";D2>2000);"Reasons";"And sht")

[@libreofficetutorials9499]

thanks

[@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.

[@libreofficetutorials9499]

I have sight issues myself

[@EasyMSAccess]

Great example thanks

[@libreofficetutorials9499]

You are welcome!

[@jongrosjean1476]

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

[@ITsEasyExcel]

really useful

[@libreofficetutorials9499]

Glad you think so!

[@Albertbullterrier]

Love it thanks

[@libreofficetutorials9499]

No problem