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-basic-if/

Learn how to create basic IF functions in Microsoft Excel to perform logical tests and return different answers based on the result. You'll learn how to construct a logical test using Excel's comparison operators such as equal to, greater than and less than. You'll learn how to compare numbers, text and date values, including how to check if a cell contains a specific phrase. You'll learn how to return simple values or perform calculations conditionally, including how to avoid potential errors.

Chapters
00:00 Topic list
00:41 Basic Logical Tests
03:40 Basic IF Functions
05:52 Conditional Calculations
08:16 Avoiding Errors
10:08 Calculations in a Logical Test
12:09 Comparing Text
13:42 Functions in Logical Tests
16:30 Testing if a String Exists
20:46 Comparing Date Values
23:22 Comparing Parts of Dates

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!