If...Then..Statement

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 anEnd If statement.

4.When a If condition is tested ,then If condition is True, the statements following Then are executed,otherwise not.