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 | Type | Description |
|---|---|---|
| X | Number | X coordinate of the point to test |
| Y | Number | Y coordinate of the point to test |
| PolygonPointsRange | Range | 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
| Type | Description |
|---|---|
| Number | -1: Point is outside of polygon 0: Point is on polygon border 1: Point is inside polygon |
Examples
| Formula | Result | Comment |
|---|---|---|
| 1 | Where B5 looks as  |