Common Function Examples 57
the line joining the two points. The Euclidean distance between two points is calcu-
lated by the following relationship:
Euclidean Distance (Point 1, Point 2) = [(x
)2 + (y
The above formula means that we take the difference in the x coordinates of two points
and square it. Then we do the same for the y coordinates, i.e., take the difference and
square it. Next, the two squared values are added and the square root of the sum is then
Table 3.3 Examples of Common Excel Functions
AVERAGE(number1, number2,…) Returns the average of its arguments.
=AVERAGE(2.6,10,-3) returns 3.2.
ABS(number) Returns the absolute value of its argu ment.
=ABS(-23.56) returns 23.56.
SUMSQ(number1, number2,…) Returns the sum of the squares of the arguments.
=SUMSQ(5,2,4) returns 45.
ROUND(number, num_digits) Rounds a number to the speciﬁed num ber of
digits after the decimal point.
=ROUND(4.6737,0) returns 5.
=ROUND(4.6737,1) returns 4.7.
=ROUND(4.6737,2) returns 4.67.
INT(number) Rounds a number down to the nearest integer.
=INT(3.7) returns 3.
=INT(5/3) returns 1.
FLOOR(number, signiﬁcance) Rounds a number down to the nearest integer or
to the nearest integer multiple of signiﬁcance.
=FLOOR(4.67,2) returns 4.
=FLOOR(4.67,0.25) returns 4.5 because 4.5
is the nearest integer multi ple (18 times) of 0.25
that is smaller than 4.67.
MOD(number, divisor) Returns the remainder after division.
=MOD(4,3) returns 1.
=MOD(5,3.3) returns 1.7.
MAX(number1, number2,…) Returns the largest number from the argument
=MAX(12,-23,43) returns 43.
PRODUCT(number1, number2,…) Returns the product of all the numbers given as
=PRODUCT(5,2.2,-4) returns –44.