Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining

# RECTSECT Function

Office 2013

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.

## Syntax

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.

## Remarks

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.

## Example

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

Returns 4.

Show:
© 2015 Microsoft