The above flow chart shows that there is only one condition or criteria, while the two outcomes are based on condition satisfaction. We can draw a flow chart of generic IF function like below: Depending on the condition and usage of several logical functions, the flow chart of the IF function may appear to range from simple to complex accordingly. General Flow Chart Structure of Excel IF FunctionĪs discussed above, the IF function works on the concept of a flow chart. It helps us specify the value that we need to return as output when the given condition (logical_test) is ‘FALSE’.

Value_if_false: It is another optional argument accepted by the IF function.

It helps us specify the value that we need to return as output when the given condition (logical_test) is ‘TRUE’.

Value_if_true: It is an optional argument accepted by the IF function.

The specified condition can be a value or a logical expression. It helps us specify the condition to be tested or evaluated as either TRUE or FALSE.

Logical_test: It is the first and the mandatory argument.The IF Formula in Excel accepts the following three arguments: The syntax of the Excel IF function is defined as below:

We can also extend the logical test functionality of the Excel IF function by combining it with other logical functions, such as AND, OR, etc. The function is mainly useful when making logical interpretations for decision-making. The working of the Excel IF function is almost similar to the appropriately structured Flow Chart. If the conditions satisfy, it results as the TRUE otherwise, FALSE. In particular, the IF function is an inbuilt conditional function that returns a value based on the fulfillment or non-fulfillment of the supplied condition.įor example, we can use the IF function to compare two values, whether the value in cell A1 is greater than that in cell B1. The function evaluates if the supplied condition satisfies and then returns an output value depending on whether the result of the condition is TRUE or FALSE. The Excel IF function performs a logical comparison between two values (or cells containing values).

How to enter if then formula in excel