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:
 |