 |
5.13
Using
functions
5.13.3
Applying
Functions
5.13.3.1
The
Round
functions
Rounds
a
number
to
a
specified
number
of
digits.
Syntax:
- ROUND(number,num_digits)
Number
is
the
number
you
want
to
round.
Num_digits
specifies
the
number
of
digits
to
which
you
want
to
round
number.
-
If
num_digits
is
greater
than
0
(zero),
then
number
is
rounded
to
the
specified
number
of
decimal
places.
-
If
num_digits
is
0,
then
number
is
rounded
to
the
nearest
integer.
-
If
num_digits
is
less
than
0,
then
number
is
rounded
to
the
left
of
the
decimal
point.
Examples
ROUND(2.15,
1)
equals
2.2
ROUND(2.149,
1)
equals
2.1
ROUND(-1.475,
2)
equals
-1.48
ROUND(21.5,
-1)
equals
20
5.13.3.2
The
Count
Functions
Counts
the
number
of
cells
that
contain
numbers
and
numbers
within
the
list
of
arguments.
Use
COUNT
to
get
the
number
of
entries
in
a
number
field
in
a
range
or
array
of
numbers.
Syntax:
- COUNT(value1,value2,
...)
Value1,
value2,
...
are
1
to
30
arguments
that
can
contain
or
refer
to
a
variety
of
different
types
of
data,
but
only
numbers
are
counted.
-
Arguments
that
are
numbers,
dates,
or
text
representations
of
numbers
are
counted;
arguments
that
are
error
values
or
text
that
cannot
be
translated
into
numbers
are
ignored.
-
If
an
argument
is
an
array
or
reference,
only
numbers
in
that
array
or
reference
are
counted.
Empty
cells,
logical
values,
text,
or
error
values
in
the
array
or
reference
are
ignored.
If
you
need
to
count
logical
values,
text,
or
error
values,
use
the
COUNTA
function.
Examples
In
the
following
example,
COUNT(A1:A7)
equals
3
COUNT(A4:A7)
equals
2
COUNT(A1:A7,
2)
equals
4
5.13.3.3
The
MAX
function
Returns
the
largest
value
in
a
set
of
values.
Syntax:
- MAX(number1,number2,...)
Number1,
number2,...
are
1
to
30
numbers
for
which
you
want
to
find
the
maximum
value.
-
You
can
specify
arguments
that
are
numbers,
empty
cells,
logical
values,
or
text
representations
of
numbers.
Arguments
that
are
error
values
or
text
that
cannot
be
translated
into
numbers
cause
errors.
-
If
an
argument
is
an
array
or
reference,
only
numbers
in
that
array
or
reference
are
used.
Empty
cells,
logical
values,
or
text
in
the
array
or
reference
are
ignored.
If
logical
values
and
text
must
not
be
ignored,
use
MAXA
instead.
-
If
the
arguments
contain
no
numbers,
MAX
returns
0
(zero).
Examples
If
A1:A5
contains
the
numbers
10,
7,
9,
27,
and
2,
then:
MAX(A1:A5)
equals
27
MAX(A1:A5,30)
equals
30
5.13.3.4
The
MIN
functions
Returns
the
smallest
number
in
a
set
of
values.
Syntax:
- MIN(number1,
number2,
...)
Number1,
number2,...
are
1
to
30
numbers
for
which
you
want
to
find
the
minimum
value.
-
You
can
specify
arguments
that
are
numbers,
empty
cells,
logical
values,
or
text
representations
of
numbers.
Arguments
that
are
error
values
or
text
that
cannot
be
translated
into
numbers
cause
errors.
-
If
an
argument
is
an
array
or
reference,
only
numbers
in
that
array
or
reference
are
used.
Empty
cells,
logical
values,
or
text
in
the
array
or
reference
are
ignored.
If
logical
values
and
text
should
not
be
ignored.
-
If
the
arguments
contain
no
numbers,
MIN
returns
0.
Examples
If
A1:A5
contains
the
numbers
10,
7,
9,
27,
and
2,
then:
MIN(A1:A5)
equals
2
MIN(A1:A5,
0)
equals
0
  
| |
