conditional formatting and advance functions of excel 2013 version

 IF Function in Excel 

IF function in Excel checks whether a condition is met and if it’s (TRUE) it returns a value, and another value if the condition does not meets (FALSE). IF function gives excel formula a decision- making capabilities. This function takes three arguments, each separated by a comma.

IF function is a very useful and most widely used conditional function in excel, this function is used to give a result based on certain criteria; for example, if condition A is met, then the value should be B, and if the condition is not met the value should be C, this function takes three arguments, the first argument is the criteria while the second argument is the result when the condition is true and third argument is when the condition is false.

Syntax 
=if(logical_test,[value_if_true],[value_if_false])