IF function in Excel

Here is a new post which will help you to use IF function in Excel.

IF function: This function tests a condition. If the condition is met it is considered to be TRUE. If the condition is not met it is considered to be FALSE. Depending upon the result, one of two actions will be carried out

Syntax: =IF(logical_test,[value_if_true], [value_if_false])
logical_test - A value or logical expression that can be evaluated as TRUE or FALSE.
value_if_true - [optional] The value to return when logical_test evaluates to TRUE.
value_if_false - [optional] The value to return when logical_test evaluates to FALSE

Example for IF function

Example 1: The following table shows the Sales figures and Targets for a sales representative. Each has its own target which they must reach. The =IF() function is used to compare the Sales with the Target. 

If the Sales are greater than or equal to the Target the result of Achieved is shown.

If the Sales do not reach the target the result Not Achieved is shown. Note that the text used in the =IF() function needs to be placed in double quotes "Achieved".




Example 2: This time the Commission to be paid to the sales a representative is calculated. If the Sales are greater than or equal to the Target, the Commission is 15% of Sales. If the Sales do not reach Target, the Commission is only 5% of Sales.