writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left">+ − + + − where+ − '''point1''' is any point with coordinates[x1,y1]+ − '''point2''' is any point with coordinates[x2,y2]+ − </div>+ − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − DISTANCE function returns the distance between two points.+ + + + + − Formula:+ − DISTANCE = sqrt( (x2-x1)^2 + (y2-y1)^2 )+ − </div> − ---- − <div id="7SpaceContent" class="zcontent" align="left"> − − DISTANCE returns NaN if any of x1,y1,x2,y2 is not real . − − </div> − ---- − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left"> − − DISTANCE − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − Lets see an example in (Column2Row1) − − <nowiki>=DISTANCE([Column1Row1,Column1Row2],[Column1Row3,Column1Row4])</nowiki> − − Returns 1.414214 for DISTANCE([2,3],[3,4]) − − </div> − ---- − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div> − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − |+ Default Calci − + − + − | Column2+ − − | Column4 − | class=" " | Row1 − | 2 − | class="sshl_f" | 1.414214 − | class=" sshl_f" | − | class="sshl_f sshl_f " | − |- class="even" − | class=" " | Row2 − | 3 − | class="sshl_f SelectTD1 ChangeBGColor SelectTD1" | − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div> − | class=" sshl_f" | − | class="sshl_f sshl_f " | − |- class="odd" − | Row3 − | class=" " | 3 − | class="sshl_f " | + − | Row4 − | class=" " | 4 − | class=" " |+ − | class=" " | Row5 − | − | class=" " | − + + − | Row6 − | − | − + − |} − − {| − | <span align="left">[[Image:calci1.gif]]</span> − | − | − [[Image:bold.gif]] − | − [[Image:italic.gif]] − | − [[Image:normal.gif]] − | − [[Image:underline.gif]] − | − [[Image:border.gif]] − | − [[Image:numbers.gif]] − | − [[Image:sort.gif]] − | − [[Image:formatcells.gif]] − | − [[Image:graphs.gif]] − | $ − − </div> − ----
Manuals/calci/DISTANCE (view source)
Revision as of 21:56, 20 November 2013
, 21:56, 20 November 2013no edit summary
=DISTANCE(point1,point2)=
'''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 ==
<div id="2SpaceContent" class="zcontent" align="left">
<div id="2SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class=" " |
| class="sshl_f" | '''Function'''
| Column1
| class="sshl_f" | '''Distance Output'''
| Column3
|- class="odd"
|- class="odd"
| class="sshl_f " |
| class="sshl_f " |
| class="sshl_f " |
| class="sshl_f " |
|- class="even"
|- class="even"
| class="sshl_f " |
| class="sshl_f " |
| class="sshl_f " |
| class="sshl_f " |
|- class="odd"
|- class="odd"
| class="sshl_f " |
| class="sshl_f " |
| class=" " |
| class="sshl_f " |
|- class="even"
|- class="even"
| class="sshl_f " |
| class="sshl_f " |
| class=" " |
| class="sshl_f " |
|}
|}