Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

RECTSECT Function

Last modified: June 17, 2011

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example

Calculates the sector of a rectangle associated with x and y and returns an integer 0 to 4, indicating the sector.

RECTSECT(width,height,x,y,option)

Parameters

Name

Required/Optional

Data Type

Description

width

Required

String

Width of the rectangle.

height

Required

String

Height of the rectangle.

x

Required

String

An x-coordinate.

y

Required

String

A y-coordinate.

option

Required

Boolean

Specifies how points that fall on the diagonals are treated. Set the value to 0 to use the left and right sectors for points on a diagonal. Set the value to 1 to use the top and bottom sectors for points on a diagonal.

Consider a rectangle that has a width and a height , and a point ( x,y ) from the center point of the rectangle. Draw diagonal lines through the corners of the rectangle to divide it into four sectors and a center point. The sectors 0 through 4 represent the center-point, right, top, left, and bottom respectively.

ShpSheetRef_CA_03_ZA07645862

RECTSECT(1 in, 2 in, 1 in, -7 in, 0)

Returns 4.

Show:
© 2015 Microsoft