VBA/Excel/Access/Word/Language Basics/Mathematical Operators

any mathematical operation that can be performed on a number can be performed on a numerical variable

   <source lang="vb">

Sub Calculation()

   Dim num1 As Integer
   Dim num2 As Integer
   Dim answer As Integer
   num1 = 10
   num2 = 5
   answer = num1 + num2    " answer Holds 15
   answer = num1 - num2    " answer Holds 5
   answer = num1 * num2    " answer Holds 50
   answer = num1 / num2    " answer Holds 2
   answer = num1 ^ 2       " answer Holds 100
   answer = 2 ^ num2       " answer Holds 32

End Sub

</source>
   
  

Common Mathematical Operators Used in VBA

   <source lang="vb">

Operation Operator Addition + Subtraction - Multiplication * Division / Exponential ^

</source>