Functions

  • Thread starter Thread starter Karl
  • Start date Start date
K

Karl

Is there a list of all function available in excel anywhere (may have found
how to round up if I had a list with roundup as a function) :-(
 
Hi Karl!

Here's the complete list of rounding and associated functions:

CEILING(number,significance):
Rounds a number (away from zero) to the nearest multiple of
significance.
EVEN(number):
Rounds a number (away from zero) to the nearest even integer.
FLOOR(number,significance):
Rounds a number (towards zero) to the nearest multiple of
significance.
INT(number):
Rounds a number to the left on a number line. (Positive rounded
towards 0, Negative rounded away from zero.)
ISEVEN(number):
Returns TRUE if a number is even. (Analysis ToolPak required).
ISODD(number):
Returns FALSE if a number is odd. (Analysis ToolPak required).
MOD(number,divisor):
Returns the remainder from division with the result having the same
sign as the divisor.
MROUND(number,multiple):
Returns a number rounded to the desired multiple. Midway points are
rounded away from 0. (Analysis ToolPak required).
ODD(number): Rounds a number away from zero to the nearest odd
integer.
QUOTIENT(numerator,denominator):

Returns the integer portion of a division.
ROUND(number,num_digits):
Rounds a number to a specified number of digits to the left (-) or
right (+) of the decimal point. The midway digit 5 is rounded away
from 0.
ROUNDDOWN(number,num_digits):

Rounds a number down towards 0 to a specified number of digits to the
left (-) or right (+) of the decimal point.
ROUNDUP(number,num_digits):
Rounds a number up away from 0 to a specified number of digits to the
left (-) or right (+) of the decimal point.
TRUNC(number,[num_digits]):
Truncates a number to an integer or to specified precision by removing
the fractional part of the number. (Serves to round down towards 0)

You can download Function Lists with classifications, sources,
descriptions, syntax and arguments from Debra Dalgleish's website that
Frank pointed to or email me direct. Each function entry in the list
provides fast access to the Help file.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thanks Norman and Frank

Hate not having list of commands (help files are OK once you know the
command)
Norman Harker said:
Hi Karl!

Here's the complete list of rounding and associated functions:

CEILING(number,significance):
Rounds a number (away from zero) to the nearest multiple of
significance.
EVEN(number):
Rounds a number (away from zero) to the nearest even integer.
FLOOR(number,significance):
Rounds a number (towards zero) to the nearest multiple of
significance.
INT(number):
Rounds a number to the left on a number line. (Positive rounded
towards 0, Negative rounded away from zero.)
ISEVEN(number):
Returns TRUE if a number is even. (Analysis ToolPak required).
ISODD(number):
Returns FALSE if a number is odd. (Analysis ToolPak required).
MOD(number,divisor):
Returns the remainder from division with the result having the same
sign as the divisor.
MROUND(number,multiple):
Returns a number rounded to the desired multiple. Midway points are
rounded away from 0. (Analysis ToolPak required).
ODD(number): Rounds a number away from zero to the nearest odd
integer.
QUOTIENT(numerator,denominator):

Returns the integer portion of a division.
ROUND(number,num_digits):
Rounds a number to a specified number of digits to the left (-) or
right (+) of the decimal point. The midway digit 5 is rounded away
from 0.
ROUNDDOWN(number,num_digits):

Rounds a number down towards 0 to a specified number of digits to the
left (-) or right (+) of the decimal point.
ROUNDUP(number,num_digits):
Rounds a number up away from 0 to a specified number of digits to the
left (-) or right (+) of the decimal point.
TRUNC(number,[num_digits]):
Truncates a number to an integer or to specified precision by removing
the fractional part of the number. (Serves to round down towards 0)

You can download Function Lists with classifications, sources,
descriptions, syntax and arguments from Debra Dalgleish's website that
Frank pointed to or email me direct. Each function entry in the list
provides fast access to the Help file.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Karl said:
Is there a list of all function available in excel anywhere (may have found
how to round up if I had a list with roundup as a function) :-(
Click to expand...
Click to expand...
 
Hi Karl!

The Worksheet Function Reference is variously located in Help in different
Versions of Excel so it does make finding harder.

Also there are some ideosyncrasies in the location of various functions:

COUNT, COUNTA and FREQUENCY are under Statistical

COUNTBLANK is under Information,

COUNTIF is provided under Maths, and

DCOUNT and DCOUNTA are provided as database functions.



COMBIN is in Maths but PERMUT is in Statistical



And in Analysis ToolPak the Engineers are trying to take over the World.



The Word version of the Function Lists also serves as a useful hardcopy that
you can browse through.
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Karl said:
Thanks Norman and Frank

Hate not having list of commands (help files are OK once you know the
command)
Norman Harker said:
Hi Karl!

Here's the complete list of rounding and associated functions:

CEILING(number,significance):
Rounds a number (away from zero) to the nearest multiple of
significance.
EVEN(number):
Rounds a number (away from zero) to the nearest even integer.
FLOOR(number,significance):
Rounds a number (towards zero) to the nearest multiple of
significance.
INT(number):
Rounds a number to the left on a number line. (Positive rounded
towards 0, Negative rounded away from zero.)
ISEVEN(number):
Returns TRUE if a number is even. (Analysis ToolPak required).
ISODD(number):
Returns FALSE if a number is odd. (Analysis ToolPak required).
MOD(number,divisor):
Returns the remainder from division with the result having the same
sign as the divisor.
MROUND(number,multiple):
Returns a number rounded to the desired multiple. Midway points are
rounded away from 0. (Analysis ToolPak required).
ODD(number): Rounds a number away from zero to the nearest odd
integer.
QUOTIENT(numerator,denominator):

Returns the integer portion of a division.
ROUND(number,num_digits):
Rounds a number to a specified number of digits to the left (-) or
right (+) of the decimal point. The midway digit 5 is rounded away
from 0.
ROUNDDOWN(number,num_digits):

Rounds a number down towards 0 to a specified number of digits to the
left (-) or right (+) of the decimal point.
ROUNDUP(number,num_digits):
Rounds a number up away from 0 to a specified number of digits to the
left (-) or right (+) of the decimal point.
TRUNC(number,[num_digits]):
Truncates a number to an integer or to specified precision by removing
the fractional part of the number. (Serves to round down towards 0)

You can download Function Lists with classifications, sources,
descriptions, syntax and arguments from Debra Dalgleish's website that
Frank pointed to or email me direct. Each function entry in the list
provides fast access to the Help file.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Karl said:
Is there a list of all function available in excel anywhere (may have found
how to round up if I had a list with roundup as a function) :-(
Click to expand...
Click to expand...
Click to expand...
 
Back
Top