Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Working with Databases playlist https://youtube.com/playlist?list=PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/sql-excel-conditional-functions/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

Learn how to use IIf and Switch functions to test conditions and produce different results depending on the answer. You'll see how to create calculated columns using the IIf and Switch functions, as well as how to use the functions to control the sort order of your query results. You'll learn how to use nested IIf and Switch functions and how to write more complex logical tests using the AND, OR, IN and BETWEEN operators.

Chapters
00:00 Topic List
00:52 The Basic Setup
03:08 Writing a Simple IIf Function
06:40 Comparing One Column to Another
08:21 Comparing Dates
10:05 Comparing Text
12:56 Using IIf to Sort Queries
15:29 Conditional Calculations
18:37 Nested IIf Functions
21:22 Combining Conditions with OR
23:00 Using the IN Operator
24:03 Combining Conditions with AND
26:10 Using the BETWEEN Operator
28:35 Tidying Up the Code
30:08 Basic Switch Functions
31:34 Including More Logical Tests
33:48 Including a Final Condition
35:33 Writing a Sequence of Logical Tests
39:05 Nested Switch Functions
44:22 Concatenating Switch Function Results
46:17 Sorting Using a Switch Function
50:05 What's Next?

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more