Tag Archives: math

Cross Products with Excel and VBA

Microsoft Excel does not have the built-in worksheet functions to calculate the cross product of two vectors. Therefore, some techniques are required to do the calculation — either by setting up your own formula in a worksheet or by creating a custom VBA function. The

How to Use the Mod Operator in VBA

Introduction Mod stands for Modulo. It is a mathematical operator that returns the remainder, or modulus, of a number after performing division. The Mod operator is not only helpful when you want to know the remainder in division, it is also powerful when you want