Using custom functions

Calling a custom function is just like calling an ordinary, built-in function. The custom function sheet containing the function must be open; you can then enter the custom function in the formula line by choosing it from the custom function section of the function selector.

The custom function dialogue box which you see will vary according to the custom functions you have loaded. If there are no custom functions loaded the list in the dialogue box will be blank.

Calling a custom function in this way creates an external reference, and therefore a dependency between your worksheet and the custom function sheet containing the custom function used.