Difference between revisions of "Manuals/calci/DISTANCE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''DISTANCE'''(point1,point2) where '''point1''' is any point with coordinates[x1,y1] '''point2''' is any po...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
=DISTANCE(point1,point2)=
  
−
'''DISTANCE'''(point1,point2)
+
*Where 'point1' is any point with coordinates[x1,y1] and
 +
*'point2' is any point with coordinates[x2,y2]
  
−
where
+
DISTANCE() calculates the distance between two points.
  
−
'''point1''' is any point with coordinates[x1,y1]
+
== Description ==
  
−
'''point2''' is any point with coordinates[x2,y2]
+
DISTANCE(point1,point2)
  
−
</div>
+
DISTANCE([2,3],[6,7]) ''returns 5.656854249492381''
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
DISTANCE function returns the distance between two points.
+
*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
  
−
Formula:
+
*If any of the co-ordinates (x1,y1,x2,y2) is non-numeric, Calci returns an error message.
  
−
DISTANCE = sqrt( (x2-x1)^2  + (y2-y1)^2 )
+
== Examples ==
  
−
</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>
 
−
----
 
 
<div id="2SpaceContent" class="zcontent" align="left">
 
<div id="2SpaceContent" class="zcontent" align="left">
  
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
−
|+ Default Calci
 
 
|- class="even"
 
|- class="even"
−
| class=" " |
+
| class="sshl_f" | '''Function'''
−
| Column1
+
| class="sshl_f" | '''Distance Output'''
−
| Column2
+
 
−
| Column3
 
−
| Column4
 
 
|- class="odd"
 
|- class="odd"
−
| 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            " |
 
 
| class="sshl_f    " |
 
| class="sshl_f    " |
 
| class="sshl_f    " |
 
| class="sshl_f    " |
 +
 
|- class="even"
 
|- class="even"
−
| Row4
 
−
| class=" " | 4
 
 
| class="sshl_f    " |
 
| class="sshl_f    " |
 
| class="sshl_f    " |
 
| class="sshl_f    " |
−
| class="  " |
+
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row5
 
−
|
 
−
| class="  " |
 
 
| class="sshl_f    " |
 
| class="sshl_f    " |
−
| class="   " |
+
| class="sshl_f    " |
 +
 
 
|- class="even"
 
|- class="even"
−
| Row6
 
−
|
 
−
|
 
 
| class="sshl_f    " |
 
| class="sshl_f    " |
−
| class="   " |
+
| class="sshl_f    " |
−
|}
 
−
 
 
−
{|
 
−
| <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>
 
−
----
 

Revision as of 15:56, 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

Function Distance Output
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/DISTANCE&oldid=195462"