Syntax of IF Function
The IF function serves a single purpose, i.e., to run tests for specific conditional statements.
Syntax: If(logical_argument,[Value_if_true],[Value_if_False])
Excel IF function With Examples
The IF function is one of Excel’s most used, if not the most used functions. It helps perform a single or a series of logical comparisons between entities. It works using the same principles as IF-ELSE conditional statements, used in most programming languages. Values satisfying the given condition, result in a positive output, while values not satisfying the given condition, result in a negative output. Condition and Return values both can be decided by the user.