Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2,”Over Budget”,”OK”) =IF(A2=B2,B4-A4,””)

The IF statement is a decision-making statement that guides a program to make decisions based on specified criteria. It executes one set of code if a specified condition is met (TRUE) or another set of code evaluates to FALSE.

The Excel IF Statement evaluates a certain condition and outputs, two values—one for a TRUE  and another for a FALSE one, the syntax for the IF statement is =IF(A1>B1, “condition”, “true or false”)