The formula editor offers capabilities to compile a standard formula into a DLL. It gives you the benefit of encapsulating your formula (function blackbox) and optimizing calculation speeds. With the Using-Statement you can include the DLL into any formula.
Easy steps for compiling the formula
1. Encapsulate your formula into a Function (AddTwoNumbers):
2. Open compile dialog:
3. Insert the function name into the dialog. Set the filename for the DLL:
|Return value is empty because we already defined one in the function.|
4. Click OK to generate the formula DLL. Go to your formula where you want to include the function and reference the formula DLL with the using statement: