When numbers are stored in variables, then you are allowed for mathematical calculation in Excel VBA, such as Addition, Subtraction, Multiplication and Division. Here are the examples of basic 4 types of mathematical operation:
Addition calculation:
Type the below codes and run it:
When you enter these codes in VBA Code window, then it will looks like this:
The mathAdd is new function you have created for running the Addition operation. You can rename this as you want but obviously following the rules of naming a Sub procedure in Excel VBA. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Addition, just used '+' sign in between X and Y. The result will show in B4 is 15.
You can use another simple way to calculate the Addition operation. But this useful only if the value is fixed and not changed. The result will show the same 15 in B4 cell.
Subtraction calculation:
Type the below codes and run it:
When you enter these codes in VBA Code window, then it will looks like this:
The mathAdd is new function you have created for running the Subtraction operation. I've used the same Sub procedure name to make you clear that, name is not a matter if you follow rules for naming a Sub procedure in Excel VBA. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Subtraction, just used '-' sign in between X and Y. This time the result will show in B4 cell is -1.
You can use another simple way to calculate the Subtraction operation. The result will show the same -1 in B4 cell.
Multiplication calculation:
Type the below codes and run it:
When you enter these codes in VBA Code window, then it will looks like this:
The mathAdd is new function you have created for running the Multiplication operation. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Multiplication, just used '*' sign in between X and Y. This time the result will show in B4 cell is 56.
You can use another simple way to calculate the Multiplication operation. The result will show the same 56 in B4 cell.
Division calculation:
Division sign are 2 types. One is Integer Division (\) and another is Decimal Division (/). The difference in between these 2 types, forward slash (/) will calculate as Decimal Division and backslash will calculate as Integer Division. That means, If you use backslash (\) then you will only see the Result as Integer Number. Below is the example of Decimal Division:
When you enter these codes in VBA Code window, then it will looks like this:
The mathAdd is new function you have created for running the Division operation. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Division, just used '/' sign in between X and Y. This time the result will show in B4 cell is 0.875.
You can use another simple way to calculate the Division operation. The result will show the same 0.875 in B4 cell.
Exponential calculation:
Type the below codes and run it:
When you enter these codes in VBA Code window, then it will looks like this:
The mathAdd is new function you have created for running the Exponential operation. You can rename this as you want but obviously following the rules of naming a Sub procedure in Excel VBA. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Exponention, just used '^' sign in between X and Y. The result will show in B4 is 5764801.
You can use another simple way to calculate the Exponential operation. But this useful only if the value is fixed and not changed. The result will show the same 5764801 in B4 cell.
Modulus (Remainder) calculation:
The Modulus operator returns the result of remainder, when divides two numbers. Type the below codes and run it:
When you enter these codes in VBA Code window, then it will looks like this:
The mathAdd is new function you have created for running the Modulus (Remainder) operation. You can rename this as you want but obviously following the rules of naming a Sub procedure in Excel VBA. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell A1 has selected to show the result. And finally for calculating the Remainder, just used MOD between X and Y. The result will show in A1 is 7.
You can use another simple way to calculate the Remainder operation. But this useful only if the value is fixed and not changed. The result will show the same 7 in A1 cell.
One thing you should remember that, Excel VBA follows the priority basis mathematical calculation. Division will come first, Multiplication is second, Subtraction is third and Addition is last. So if you thing that, 6 + 15 / 3 will return 7 then you are wrong, it will return 11.
Addition calculation:
Type the below codes and run it:
Sub mathAdd()
Dim x As Integer
Dim y As Integer
x = 7
y = 8
Range("B4").Value = x + y
End Sub
When you enter these codes in VBA Code window, then it will looks like this:
Image 1: Addition calculation in Excel VBA
The mathAdd is new function you have created for running the Addition operation. You can rename this as you want but obviously following the rules of naming a Sub procedure in Excel VBA. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Addition, just used '+' sign in between X and Y. The result will show in B4 is 15.
Image 2: Addition calculation
You can use another simple way to calculate the Addition operation. But this useful only if the value is fixed and not changed. The result will show the same 15 in B4 cell.
Sub mathAdd()
Dim x As Integer
x = 7 + 8
Range("B4").Value = x
End Sub
Subtraction calculation:
Type the below codes and run it:
Sub mathAdd()
Dim x As Integer
Dim y As Integer
x = 7
y = 8
Range("B4").Value = x - y
End Sub
When you enter these codes in VBA Code window, then it will looks like this:
Image 3: Subtraction calculation in Excel VBA
The mathAdd is new function you have created for running the Subtraction operation. I've used the same Sub procedure name to make you clear that, name is not a matter if you follow rules for naming a Sub procedure in Excel VBA. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Subtraction, just used '-' sign in between X and Y. This time the result will show in B4 cell is -1.
Image 4: Subtract calculation
You can use another simple way to calculate the Subtraction operation. The result will show the same -1 in B4 cell.
Sub mathAdd()
Dim x As Integer
x = 7 - 8
Range("B4").Value = x
End Sub
Multiplication calculation:
Type the below codes and run it:
Sub mathAdd()
Dim x As Integer
Dim y As Integer
x = 7
y = 8
Range("B4").Value = x * y
End Sub
When you enter these codes in VBA Code window, then it will looks like this:
Image 5: Multiplication calculation in Excel VBA
The mathAdd is new function you have created for running the Multiplication operation. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Multiplication, just used '*' sign in between X and Y. This time the result will show in B4 cell is 56.
Image 6: Multiplication calculation
You can use another simple way to calculate the Multiplication operation. The result will show the same 56 in B4 cell.
Sub mathAdd()
Dim x As Integer
x = 7 * 8
Range("B4").Value = x
End Sub
Division calculation:
Division sign are 2 types. One is Integer Division (\) and another is Decimal Division (/). The difference in between these 2 types, forward slash (/) will calculate as Decimal Division and backslash will calculate as Integer Division. That means, If you use backslash (\) then you will only see the Result as Integer Number. Below is the example of Decimal Division:
Sub mathAdd()
Dim x As Integer
Dim y As Integer
x = 7
y = 8
Range("B4").Value = x / y
End Sub
When you enter these codes in VBA Code window, then it will looks like this:
Image 7: Division calculation in Excel VBA
The mathAdd is new function you have created for running the Division operation. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Division, just used '/' sign in between X and Y. This time the result will show in B4 cell is 0.875.
Image 8: Division calculation
You can use another simple way to calculate the Division operation. The result will show the same 0.875 in B4 cell.
Sub mathAdd()
Dim x As Integer
x = 7 / 8
Range("B4").Value = x
End Sub
Exponential calculation:
Type the below codes and run it:
Sub mathAdd()
Dim x As Integer
Dim y As Integer
x = 7
y = 8
Range("B4").Value = x ^ y
End Sub
When you enter these codes in VBA Code window, then it will looks like this:
Image 9: Exponential calculation in Excel VBA
The mathAdd is new function you have created for running the Exponential operation. You can rename this as you want but obviously following the rules of naming a Sub procedure in Excel VBA. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell B4 has selected to show the result. And finally for calculating the Exponention, just used '^' sign in between X and Y. The result will show in B4 is 5764801.
Image 10: Exponential calculation
You can use another simple way to calculate the Exponential operation. But this useful only if the value is fixed and not changed. The result will show the same 5764801 in B4 cell.
Sub mathAdd()
Dim x As Integer
x = 7 ^ 8
Range("B4").Value = x
End Sub
Modulus (Remainder) calculation:
The Modulus operator returns the result of remainder, when divides two numbers. Type the below codes and run it:
Sub mathAdd()
Dim x As Integer
Dim y As Integer
x = 7
y = 8
Range("A1").Value = x Mod y
End Sub
When you enter these codes in VBA Code window, then it will looks like this:
Image 11: Modulus (Remainder) calculation in Excel VBA
The mathAdd is new function you have created for running the Modulus (Remainder) operation. You can rename this as you want but obviously following the rules of naming a Sub procedure in Excel VBA. Then Dim declared variable names as X and Y where 7 and 8 values are stored. The cell A1 has selected to show the result. And finally for calculating the Remainder, just used MOD between X and Y. The result will show in A1 is 7.
Image 12: Remainder calculation
You can use another simple way to calculate the Remainder operation. But this useful only if the value is fixed and not changed. The result will show the same 7 in A1 cell.
Sub mathAdd()
Dim x As Integer
x = 7 Mod 8
Range("A1").Value = x
End Sub
One thing you should remember that, Excel VBA follows the priority basis mathematical calculation. Division will come first, Multiplication is second, Subtraction is third and Addition is last. So if you thing that, 6 + 15 / 3 will return 7 then you are wrong, it will return 11.