Share via

Enter Value For Dialog Box

  • Article

This dialog box appears when you select the Enter Constant Value option from the Value list in the Function Arguments area of the Formula Expert.

Not every argument type requires the use of this dialog box; simple types that don't have formatting restrictions (such as you'd encounter with a date field, for example), can be entered directly.

The complete dialog box name appends the selected argument's name and type. For example, if you select a DateTime argument called "DayInQuarter," the dialog box name appears as "Enter Value for DayInQuarter (DateTime)."

There are different versions of this dialog box to accommodate each of the following:

  • The selection of a single value.
  • The selection of a range of values.
  • The selection of an array of values.
  • The selection of an array of ranged values
Single value Use the options in this dialog box to select a single value to use in your formula. You can create a formula with a value such as CDateTime (2001, 12, 07, 15, 50, 18) by using this version of the dialog box.
Range of values Use the options in this dialog box to select a starting and ending value to use as the bounds of your formula's range. You can create a formula with a range such as (10000 To 50000) by using this version of the dialog box.

Note

The options in the Value list let you define more exactly how the formula's range is to be calculated. The list includes options such as "is between, including endpoints," "is between, excluding endpoints," and so on.
Array of values Use the options in this dialog box to select an array of values to use in your formula. You can create a formula with an array such as (["Canada", "England", "USA"]) by using this version of the dialog box.
Array of ranged values Use the options in this dialog box to select an array of ranged values to use in your formula. You can create a formula with an ranged array such as (["AL" To "AZ", "CA" To "CT"]) by using this version of the dialog box.

Note

The options in the Value list let you define more exactly how each range in the formula's array is to be calculated. The list includes options such as "is between, including endpoints," "is between, excluding endpoints," and so on.

See Also