Difference between revisions of "Manuals/calci/DISTANCE"
Jump to navigation
Jump to search
| Line 26: | Line 26: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class="sshl_f | + | | class="sshl_f" | '''DISTANCE()''' |
| − | | class="sshl_f | + | | class="sshl_f" | '''Output''' |
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f | + | | class="sshl_f" | ([4,8],[3,6]) |
| − | | class="sshl_f | + | | class="sshl_f" | 2.23606797749979 |
|- class="even" | |- class="even" | ||
| − | | class="sshl_f " | | + | | class="sshl_f " | ([-4,2],[7,-3]) |
| class="sshl_f " | | | class="sshl_f " | | ||
|- class="odd" | |- class="odd" | ||
| − | | class="sshl_f " | | + | | class="sshl_f " | ([-2,-3],[-3,-2]) |
| class="sshl_f " | | | class="sshl_f " | | ||
|- class="even" | |- class="even" | ||
| − | | class="sshl_f " | | + | | class="sshl_f " | ([10,0],[3,6]) |
| class="sshl_f " | | | class="sshl_f " | | ||
|} | |} | ||
Revision as of 16:10, 20 November 2013
DISTANCE(point1,point2)
- Where 'point1' is any point with coordinates[x1,y1] and
- 'point2' is any point with coordinates[x2,y2]
DISTANCE() calculates the distance between two points.
Description
DISTANCE(point1,point2)
DISTANCE([2,3],[6,7]) returns 5.656854249492381
- This function returns the distance between two points using the following formula -
DISTANCE = SQRT( (x2-x1)^2 + (y2-y1)^2 )
= SQRT((6-2)^2 + (7-3)^2)
= SQRT(32)
= 5.656854249492381
- If any of the co-ordinates (x1,y1,x2,y2) is non-numeric, Calci returns an error message.
Examples
| DISTANCE() | Output |
| ([4,8],[3,6]) | 2.23606797749979 |
| ([-4,2],[7,-3]) | |
| ([-2,-3],[-3,-2]) | |
| ([10,0],[3,6]) |