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.
=CLASSIFYPOINT(X, Y, PolygonPointsRange)
|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|
-1: Point is outside of polygon 0: Point is on polygon border 1: Point is inside polygon
=CLASSIFYPOINT(500, 500, [object Object])
|1||Where A2:B5 looks as follows:|