Re: Help with Course Work

From: Norman Harker (njharker_at_optusnet.com.au)
Date: 02/26/04 

Date: Fri, 27 Feb 2004 10:19:00 +1100

Hi Chillout!

Here's a list of functions associated with rounding like activities:

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)

For Examples see Help for each function. The ones you need to look at
are ROUNDUP and CEILING. 

-- 
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.
"chillout@hotmail.com" <anonymous@discussions.microsoft.com> wrote in
message news:2b9e01c3fcbd$4a212310$a501280a@phx.gbl...
> Hi There
>
> Wot is the formula for rounding up a number in Excel and
> please could you give examples.
>
> Thank you
>
> Chillout

Relevant Pages

  • Re: continued fractions
    ... Because rounding 0 to zero is no change. ... Meanwhile the range [1..5) also rounds down, ... you with a logarithmic distribution for the first digit. ... digits beyond the first will also be affected. ...
    (comp.lang.forth)
  • Re: continued fractions
    ... Because rounding 0 to zero is no change. ... Four non-zero digits round down, ... Meanwhile the range [1..5) also rounds down, ... The biggest bias occurs when rounding off one digit. ...
    (comp.lang.forth)
  • Re: Functions
    ... > Rounds a number (away from zero) to the nearest even integer. ... > Excel and Word Function Lists ...
    (microsoft.public.excel.misc)
  • Re: Help with Course Work
    ... >Rounds a number (away from zero) to the nearest multiple ... >Rounds a number to a specified number of digits to the ...
    (microsoft.public.excel.misc)
  • Re: Functions
    ... Rounds a number to the nearest multiple of ... Rounds a number (away from zero) to the nearest even integer. ... Excel and Word Function Lists ...
    (microsoft.public.excel.misc)
Loading