Re: Help with Course Work

From: Chillout (anonymous_at_discussions.microsoft.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 15:09:25 -0800

Hi Norman

Many thanks for your help with the question your the
first to give good advice which is very much appreciated,
sorry i have not replied sooner as i have just got in
from doing a very late afternoon/ evening shift.

Once again many thanks for your help

Chillout

>-----Original Message-----
>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 to the nearest multiple of ... Rounds a number (away from zero) to the nearest even integer. ... Rounds a number down towards 0 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