| 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
Comments