Main Content

Find Custom MATLAB Function Using MATLAB Function Wizard

This example shows how to write a custom function and find it by using the MATLAB® Function Wizard for Spreadsheet Link™.

Create and save a custom function in MATLAB. First, create a help header in the function that contains supported function signatures to use with the MATLAB Function Wizard. Write the function that calculates the Fibonacci numbers, and then save the function in the folder Documents\MATLAB.

function f = fibonacci(n)
% FIBONACCI(N)  Calculate the Nth Fibonacci number.
% N must be a positive integer.
    if n < 0
        error('Invalid number.')
    elseif n == 0
        f = 0;
    elseif n == 1
        f = 1;
        f = fibonacci(n - 1) + fibonacci(n - 2);

For writing MATLAB functions, see Create Functions in Files.

Add the folder where you saved the function to the MATLAB search path. You can use the pathtool function or select Set Path in the MATLAB Toolstrip.

Open the MATLAB Function Wizard in Microsoft® Excel® using either the Microsoft Excel ribbon or context menu. Select the folder where you saved your function.

MATLAB Function Wizard contains the selected Documents\MATLAB category, fibonacci function, fibonacci function signatures, and the fibonacci function help.

To execute this function, follow the steps in Find and Execute MATLAB Function Using MATLAB Function Wizard.

See Also


Related Topics