For this, you'd normally use one of the logical operators.
The syntax of the IF function is as follows: IF is one of logical functions that evaluates a certain condition and returns one value if the condition is TRUE, and another value if the condition is FALSE. IF statement for blank and non-blank cells.
How to use IF function in Excel - formula examples.In this tutorial, we are going to learn the syntax and common usages of the Excel IF function, and then take a closer look at formula examples that will hopefully prove helpful to both beginners and experienced users. Generally, you use an IF statement to test a condition and to return one value if the condition is met, and another value if the condition is not met. IF is one of the most popular and useful functions in Excel. In this article, you will learn how to build an Excel IF statement for different types of values as well as how to create multiple IF statements.