User`s guide

4 Function Wizard
Argument Properties
The Argument Properties and related dialog boxes allow you to select
worksheet ranges or optionally enter a specific value for an input argument.
These dialog boxes are as follows:
• “Input Argume nt Properties Dialog Box” on page 4-12
• “Output Argument Properties Dialog Box” on page 4-13
InputArgumentPropertiesDialogBox
Here is an example of the Argument Properties dialog box for input
arguments. In this example, the input arguments have a range of
A1 to A10.
From this d
ialog box you can
• Select the
Range list to specify a range o f current input arguments.
• Click Auto
recalclulate on change to tell E xcel Builder to recalculate
the curren
t function when any cell in the current argument changes.
• Select the
Value list to set a single value for the current argument. Then
select the
type from the Type list.
• Click Opti
ons to set the conversion optio ns. Then set the options in t he
Input Con
version Options dialog box as shown:
4-12