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:

$$\sqrt{ \sum_{i=1}^n a_i^2 }$$

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