Export (0) Print
Expand All
Expand Minimize

INTERSECTY Function

Last modified: June 17, 2011

Applies to: Office 2013 | Visio 2013

In this article
Syntax
Remarks
Example

Returns the y-coordinate (in the local coordinate system) of the point where two lines intersect.

INTERSECTX(x1,y1,angle1,x2,y2,angle2)

Parameters

Name

Required/Optional

Data Type

Description

x1

Required

Number

The x-coordinate of a point on the first line.

y1

Required

Number

The y-coordinate of a point on the first line.

angle1

Required

Number

The value of the Angle cell for the first line.

x2

Required

Number

The x-coordinate of a point on the second line.

y2

Required

Number

The y-coordinate of a point on the second line.

angle2

Required

Number

The value of the Angle cell for the second line.

Return Value

Number

Each line is defined as a point ( x,y ) and an angle.

Microsoft Visio uses this function in the PinY cell of a shape glued to a rotated guide.

If the lines don't intersect, the function returns a divide-by-zero error (#DIV/0!), which Visio ignores, restoring the last known value for the point.

INTERSECTY(VertGuide!PinX,VertGuide!PinY,VertGuide!Angle, HorzGuide!PinX,HorzGuide!PinY,HorzGuide!Angle)

Returns the y -coordinate of the intersection point of VertGuide and HorzGuide in page units.

Show:
© 2014 Microsoft