This tutorial demonstrates how to use the IF Function in Excel and Google Sheets to create If Then Statements . IF Function Overview The IF Function Checks Learn how to use the IF function in Excel to check whether a condition is met and return different values depending on the result. See simple and complex examples, comparison operators, AND/OR criteria, nested IF and more. This comprehensive guide will teach you how to create and use Excel IF statements with multiple conditions with screenshots. Learn how to use the IF function in Excel to automate tasks based on logical tests. See how to write basic, text, case-sensitive, and partial match IF -THEN statements with practical examples and a free workbook.