Help with Course Work

  • Thread starter Thread starter chillout
  • Start date Start date
C

chillout

Hi There

Wot is the formula for rounding up a number in Excel and
please could you give examples.

Thank you

Chillout
 
You're not going to get much out of your course unless you make a bit of an
effort. Try looking up the help for ROUND, ROUNDUP, ROUNDDOWN. Books are
good too.

Regards

Trevor
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Thankyou for your advice Trevor, but i was having trouble
with the help due to it malfunctioning on the computer
but now i have got this working tonight and hey where am
i going to get a book late at night - not the petrol
station for sure.

Chillout
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"(e-mail address removed)"
Click to expand...
 
Back
Top