Formula Engine Reference Guide
 

 

Back to Class Index

 

VECLEN(argumentlist)

Description
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.
 
Parameters
argumentlist

Any combination of numbers, cells or ranges
 
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