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. How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values. Learn how to use the IF function in Excel to perform logical comparisons and return different results depending on the outcome. See syntax, examples, common problems and related functions. 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.