X-Stream Operator’s Manual
WM-OM-E Rev I 295
Z = Y
End If
End If
This is equivalent to:
If ( (A > 0) And (B > 0) ) Then
Z = Y
End If
Summary of If . . . . Then . . . . Else
If Boolean Then AnyVBScriptingOnOneLine
If Boolean Then
AnyVBScriping
End If
If Boolean Then
AnyVBScripting
Else
AnyOtherVBScripting
End If
If you write a list like this, all the Booleans will be evaluated, whether you want that or not:
If A > 9 Then VBScripting1
If A > 7 Then VBScripting2
If A > 6 Then VBScripting3
If A > 4 Then VBScripting4
If A > 3 Then VBScripting5
If A > 1 Then VBScripting6
Be very careful when testing for equality. There will be no trouble with Integers, Long Integers, and
Strings, but Real numbers are different. Because they have so many significant digits, values that
should be equal, may differ minutely after a computation. It is safer with Real numbers to test using
a tolerance band.
File for this example: IfThenElse.xls
If you find that you are building up a rather complicated set of Ifs, you might want to consider the
Select Case construction.
Select Case
This is a very powerful construction, which is also easy to understand when written out. It is best for
To Next Page
Loading...
Need help?
General
