Re: Functions
From: Norman Harker (njharker_at_optusnet.com.au)
Date: 03/07/04
- Next message: Richard Massey: "Grouping Pivot Table Data"
- Previous message: Charles Williams: "Re: display of calculation result is wrong"
- In reply to: Karl: "Functions"
- Next in thread: Karl: "Re: Functions"
- Reply: Karl: "Re: Functions"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 8 Mar 2004 10:01:19 +1100
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 njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Karl" <news@addrison.co.uk> wrote in message news:c2fpjj$1sqr6b$1@ID-152276.news.uni-berlin.de... > 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) :-( > >
- Next message: Richard Massey: "Grouping Pivot Table Data"
- Previous message: Charles Williams: "Re: display of calculation result is wrong"
- In reply to: Karl: "Functions"
- Next in thread: Karl: "Re: Functions"
- Reply: Karl: "Re: Functions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
