The If…Then statement is used to evaluate whether a condition is True or False.
You can use If…Then block to execute one or more statements conditionally.
Syntax:
If <condition> Then
[statements]
Else
[else statements]
End If
Example:
if a>5 Then a=a+10
Here condition is that ‘a’ should be greater than 5 and if it is true then ‘a’ should be incremented by 10.
<condition>:-The condition is usually a comparison, but it can be any expression that evaluates to a numeric value.
[Statements] :- One or more statements separated by colons; executed if condition is True.
Note that:
1.A single line of If…Then does not use End If statement.
Syntax:-
If condition Then statement.
But if you use this in more than one line ,then syntax will be If…Then…End If.
2.If anything other than a comment appears after Then on the same line, the statement is treated as a single line If statement.
3.A block If statement must be the first statement on a line. The block If must end with an End If statement.
4.When a If condition is tested ,then If condition is True, the statements following Then are executed,otherwise not.