Nested if statements in excel

Here is a new post which will help you to understand Nested IF statements in Excel.

IF statement is a test 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. similarly nested if statement is one in which multiple conditions can be checked.

Syntax of IF:  =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

General form of nested IF function

IF(Trial1,result1,IF(Trial2,result2,IF(Trial3,result3,IF(Trial4,result4,result5))))

Trial1-Trial5 represents 5 different logical Trials, and Result1-Result5 represents 5 different Results. 

This section describes the Excel nested IF construction. Usually, nested IFs are used when you need to test more than one condition and return different results depending on those tests. The methods of nested if is to decide a direction (high to low, or low to high), then structure the conditions accordingly.

Example for Nested IF Statement

Below is the grading system used to respect the score of different students and nested IFs work fine here.



Note that the text used in the =IF() function needs to be placed in double quotes "Achieved".

link for if statement and other logical test/statement in excel

Example for IF Statement

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.

You can also get more information about the logical Test click here..

Note: The text used in the =IF() function needs to be placed in double quotes "A+".