Whatever your custom function does, it must produce a result.
You do this using the RESULT
function, in the following form:
Syntax:
RESULT(value)
You may enter either a specific value, a formula, or a cell reference in the custom function sheet.
Example:
The tangent
custom function has the following RESULT
:
RESULT(sin(@angle)/cos(@angle))
The value here is returned to the cell in the worksheet from which the custom function was called.