Declaring the result

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.