RECTSECT Function
Last modified: March 09, 2015
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.