Nested If

Syntax -

If (condition1, value_if_true1, If (condition2, value_if_true2, value_if_false2)) EndIf EndIf

Description:

       It is possible to nest multiple If functions within one formula. You can nest several If functions to create a complex If THEN Else statement.

Note: This would be equivalent to the following If THEN Else statement:

Sample:

This syntax example demonstrates how to nest two If functions.  Condition is the value that you want to test.  Value_if_true is the value that is returned if condition evaluates to TRUE.  Value_if_false is the value that is return if condition evaluates to FALSE.

If condition1 Then

       value_if_true1

ElseIf condition2 Then

       If condition3 eq "3rd Condition" Then

               value_if_true3

       EndIf                

       value_if_true2

Else

       value_if_false2

EndIf