Standard Math Functions
|
Math Function
|
Evaluates:
|
|
|
Less than? |
|
<>
|
Not |
|
>
|
Greater than? |
|
+
|
Add |
|
*
|
Multiply |
|
()
|
Math Brackets |
|
-
|
Subtract |
|
^
|
Power of |
| / |
Divide |
You can use these as if you were using a calculator. The standard rule applies
that division and multiplication are calculated before addition and subtraction,
unless you use brackets. For example,
3 + 2 * 5 = 13 ' 2 multiplied by 5 is 10, then, add 3 which
gives us 13
(3 + 2) * 5 = 25 ' 3 and 2 equals 5, and then multiply the 5 by 5, which gives
us 25
The noticeable differences between a calculator and Visual Basic is that the
signs used are slightly different. Look at the table below to see what I mean.
For example, the following code performs a number of functions on a number,
and displays a message box with the result
' Multiply
Msgbox "Multiply 1 * 32: " & 1 * 32
' Divide
Msgbox "Divide 32 / 12: " & 32 / 12
' Power of 3
Msgbox "Power 9 ^ 3: " & 9 ^ 3
' Greater than 100?
Msgbox "234 greater than 100? " & 234 > 100