Navigation:  Erlang for Excel >

Using Erlang for Excel

Print this Topic Previous pageReturn to chapter overviewNext page

Erlang for Excel introduces eight Erlang functions to Microsoft Excel, thus allowing you to incorporate Erlang calculations into your own spreadsheets.

 

The functions are provided as Add-ins, rather than macros, and this distinction is important to understand. The code for performing the calculations is installed with Excel's installation rather than within workbooks. This means that workbooks that use Erlang for Excel's functions are not transportable. When you send such a workbook to another computer, you are only sending references to the functions; not the methods of performing the calculations. So, Erlang for Excel must be installed on each computer on which the calculations need to be resolved.

 

You can enter a function in Excel in the same way as you add a normal data, except that the formula must start with the = sign. This tells Excel that what follows is an Excel function. Each functions takes a number of parameters. As with other Excel functions, you can either enter absolute values as the parameters, or you can add references to other cell on the same workbook or other open workbooks.

 

Functions will return the error #NUM! if the entered value is out of the operational limits of that function. The operational limits are shown in the function references. A function will return the error #N/A if the add-in installation is unlicensed. Please contact us to purchase a licence.

 

See also

 

Erlang for Excel functions

Example calculators