CLASSIFYPOINTΒΆ

This function determines whether a given X, Y coordinate is inside or outside or on the border of a given polygon defined by the points given.

Syntax

=CLASSIFYPOINT(X, Y, PolygonPointsRange)

Arguments

Name

Description

X

X coordinate of the point to test

Y

Y coordinate of the point to test

PolygonPointsRange

A vertical range with 2 columns and N rows where the first column contains the X and the second column contains the Y coordinates of a (closed) Polygon

Return Value

-1: Point is outside of polygon
0: Point is on polygon border
1: Point is inside polygon

Example

Function

Result

Comment

=CLASSIFYPOINT(500, 500, A2:B5)

1

Where A2:B5 looks as follows:

CLASSIFYPOINT