Nested+IF+Statements

__**Nested IF Statements**__

We are all familiar with the IF statement in excel, which are used to output a relevant result based upon whether a specific condition is true or false. But there are certain scenarios where we need to check for more than one condition and that is where Nested IF's are used.

//__Syntax:__//

Regular IF Statement:

IF(condition1, result_if_true1, result_if_false1)

Nested IF statament:

IF(condition1, result_if_true1, IF(condition2, result_if_true2, result_if_false2 ))

We can write the above Nested IF syntax in another format as follows:

IF //condition1// THEN //result_if_true//1 ELSEIF //condition2// THEN //result_if_true2// ELSE //result_if_false2// END IF

__//Note://__ One thing we need to keep note of is that the Nested IF's cannot go on for ever. In older versions of office the limit for the Nested IF's was 7 but in Office 2007 the limit has been increased to 64. However, one should always be aware of backward compatibility as Nested IF statements created in Office 2007 which are more than 7 in size will be automatically reduced to 7 if the same file is opened in Office 2003 or earlier.