下表列出了所有VBScript语言支持的算术运算符。假设变量A=5和变量B=10,则:
| 运算符 | 描述 | 例子 |
|---|---|---|
| + | 相加两个操作数 | A + B = 15 |
| - | 第一操作数减去第二操作数 | A - B = -5 |
| * | 两个操作数相乘 | A * B = 50 |
| / | 通过分子除以分母 | B / A = 2 |
| % | 模运算和整数相除后的余 | B MOD A = 0 |
| ^ | 求幂运算符 | B ^ A = 100000 |
添加一个按钮,并尝试下面的例子来了解所有可用的算术运算符在VBA中:
Private Sub Constant_demo_Click()
Dim a As Integer
a = 5
Dim b As Integer
b = 10
Dim c As Double
c = a + b
MsgBox ("Addition Result is " & c)
c = a - b
MsgBox ("Subtraction Result is " & c)
c = a * b
MsgBox ("Multiplication Result is " & c)
c = b / a
MsgBox ("Division Result is " & c)
c = b Mod a
MsgBox ("Modulus Result is " & c)
c = b ^ a
MsgBox ("Exponentiation Result is " & c)
End Sub
当单击按钮或执行该脚本,这会产生以下结果:
Addition Result is 15 Subtraction Result is -5 Multiplication Result is 50 Division Result is 2 Modulus Result is 0 Exponentiation Result is 100000