next up previous contents index
Next: VLOOKUP Up: A Function Reference Previous: VDB

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:

displaymath16425

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


next up previous contents index
Next: VLOOKUP Up: A Function Reference Previous: VDB

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999