9.Excel IF Function
Excel IF Function
Learn how to use the IF function in Excel. The IF function is one of the most common and useful functions in Excel, and it allows you to create logical statements in your formulas.
What is the IF function?
The IF function takes three arguments: a logical test, a value to return if the logical test is true, and a value to return if the logical test is false. The IF function returns the value of the second argument if the logical test is true, and the value of the third argument if the logical test is false.
How to use the IF function
The general syntax for the IF function is as follows:
IF(logical_test, value_if_true, value_if_false)