BOUND Function
Constrains the value of a cell to a range or set of ranges.
Syntax
BOUND (value, type, ignore, value1, value2 [,ignore(n), value1(n), value2(n),...])
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
value |
Required |
Numeric |
The current value being constrained. |
type |
Required |
Numeric |
Whether the constraint is inclusive (0), exclusive (1), or disabled (2). |
ignore |
Required |
Boolean |
TRUE to ignore the range; FALSE to constrain the value of the cell to the range. |
value1 |
Required |
Numeric |
First value in a range. |
value2 |
Required |
Numeric |
Second value in a range. |
Remarks
Use the BOUND function to restrict a cell's value to an upper and lower bound, for example, to control objects that should not be stretched above or below a minimum or maximum height. The constraint can be inclusive or exclusive with respect to the range or ranges. If the current value should not be constrained, set the type parameter to 2 (disabled).
You can define multiple ranges by supplying multiple occurrences of the ignore, value1, and value2 parameters. Use the ignore parameter to disable constraints by a particular range.
The formula containing the BOUND function does not get overwritten when its value changes; instead, the formula is preserved and the new value is placed into the value parameter.
Example 1
This example uses the BOUND function to force a control handle to stay within the bounding box of a shape.
Controls.X1 = BOUND(Width*0.5, 0, FALSE, Width*0, Width*1)
Controls.Y1 = BOUND(Height*0.5, 0, FALSE, Height*0, Height*1)
Example 2
This example uses the BOUND function to constrain a shape's width to 2 inches, 4 inches, or 6 inches.
Width = BOUND(, 0, FALSE, 2 in, 2 in, FALSE, 4 in, 4 in, FALSE, 6 in, 6 in)