Calculating Least Common Multiple (LCM) Using VBA Code in Excel


A VBA macro in Excel calculates the Least Common Multiple (LCM) of a list of input values provided from GoldSim. The LCM is then imported by GoldSim and displayed in a dashboard. For comparison, the LCM is also calculated using a Script element that implements an algorithm very similar to the VBA algorithm.


Making Better Decisions In An Uncertain World