next up previous contents index
Next: VLOOKUP, XLVLOOKUP Up: A. Function Reference Previous: VDB   Contents   Index


VECLEN

Syntax: VECLEN(argumentlist)

argumentlist = Any combination of numbers, cells or ranges

VECLEN returns the square root of the sum of squares of its arguments. It calculates the length of a vector in N-dimensional space. In the two-argument case, VECLEN is the Pythagorean theorem for the hypotenuse of a right triangle, given the length of the other two sides. The formula is given by:

\begin{displaymath}
\sqrt{ \sum_{i=1}^n a_i^2 }
\end{displaymath}

Examples:

VECLEN(3, 4) = 5

VECLEN(-1, -2, -3, 0) = 3.7416574

VECLEN(A1..A2) = 2 where A1 = 1 and A2 = 2.236068

VECLEN(S1..S3, 4) = 5.4772256, where S1 = 1, S2 = 2, and S3 = 3

Excel function: N/A


next up previous contents index
Next: VLOOKUP, XLVLOOKUP Up: A. Function Reference Previous: VDB   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003