BOUND Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example 1
Example 2

Constrains the value of a cell to a range or set of ranges.

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.

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.

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)

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)

Show: