By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Download files here https://www.wiseowl.co.uk/excel/videos/excel-general/excel-and-or-not/
Learn how to combine logical tests in Microsoft Excel using the AND, OR and NOT logical functions.
Chapters
00:00 Topic list
00:38 A Recap of Logical Tests
02:31 Combining Logical Tests with the AND Function
05:50 Combining Logical Tests with the OR Function
07:37 Conditions with Text
09:21 Combining Conditions in Nested IFs
11:13 Finding Numbers Between Two Values
12:50 Finding Dates Between Two Dates
15:01 A Basic NOT Function Example
17:43 Using NOT with Other Functions
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!