Use the IF Function to test if a condition is TRUE. If the condition is TRUE then do one thing. If it’s FALSE then do another. The condition must be a logical expression (ex: a1 5), a reference to a cell containing TRUE or FALSE, or an array containing all logical values. The IF Function can only test one condition at a time. Nov 12, 2013 Excel If Then Statements: Getting the Most Out of the IF Function Background on the IF function. Like most of the functions you are familiar with in Excel. Creating an if function. The syntax of an IF function is pretty simple. Applying the IF function to a range of values.
Nested If FunctionsThis is the most basic type of ‘complex’ if function. You can use an additional if function to create a more complex condition within your Excel formula.For instance: =IF(A110,IF(A110,IF(A110,A110,A2.