Manuals/calci/DISTANCE
Jump to navigation
Jump to search
DISTANCE(point1,point2)
where
point1 is any point with coordinates[x1,y1]
point2 is any point with coordinates[x2,y2]
DISTANCE function returns the distance between two points.
Formula:
DISTANCE = sqrt( (x2-x1)^2 + (y2-y1)^2 )
DISTANCE returns NaN if any of x1,y1,x2,y2 is not real .
DISTANCE
Lets see an example in (Column2Row1)
=DISTANCE([Column1Row1,Column1Row2],[Column1Row3,Column1Row4])
Returns 1.414214 for DISTANCE([2,3],[3,4])
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | 1.414214 | ||
| Row2 | 3 | |||
| Row3 | 3 | |||
| Row4 | 4 | |||
| Row5 | ||||
| Row6 |
| File:Calci1.gif | $ |
