User`s guide

5 Function Wizard
5-14
Copy Function
Use the Copy Function dialog box to make copies of the current function. The
Standard Copy tab creates a specified number of copies of the function while
copying any argument/range values you have set.
The
Advanced tab creates a rectangular array of copies of the current function
in the current worksheet, and optionally copies the cell contents of ranges
referenced by the function’s arguments. When you set the number of rows and
columns and the row/column increments, the copy process automatically
updates cell references by the specified increment amounts.
• Positive increments move rows down and columns to the right. Negative
increments move rows up and columns to the left.
Enter number of
copies.
Make copies and
return to
Function Viewer.
Return to
Function Viewer
without making
copies.
Set size and positioning of
copies.