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:
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