Hi

How to roundoff the decimal points to the nearest whole integer?

Thanks
--
Life isa journey not a destination

On Sun, 17 Jan 2010 05:46:01 -0800, Sherees
wrote:

Hi

How to roundoff the decimal points to the nearest whole integer?

Thanks

=round(ur_number_or_cell_reference,0)

--ron

Checkout the ROUND function.
Micky


"Sherees" wrote:

Hi

How to roundoff the decimal points to the nearest whole integer?

Thanks
--
Life isa journey not a destination

Is there a way to achieve such a roundup across a range of cells?
I understand =round(your_cell_reference,0) but that produces the rounded
value of, say A3 in, say, B3.
I often need to reduce a range of cells by a specified %. I then enter, say
..97 into a cell - so as to achieve a 3% reduction - and then copy/paste
special/multiply across range. This will give me results that are not whole
integers, but it is whole integers that are needed. (I then go in and
manually change the range values to the whole integers that I need, and this
can sometimes be 100s of cells!)
Anyone got some brillant way of doing this? Many thanks in advance!

"Sherees" wrote:

Hi

How to roundoff the decimal points to the nearest whole integer?

Thanks
--
Life isa journey not a destination

On Sun, 17 Jan 2010 17:16:02 -0800, Al wrote:

Is there a way to achieve such a roundup across a range of cells?
I understand =round(your_cell_reference,0) but that produces the rounded
value of, say A3 in, say, B3.
I often need to reduce a range of cells by a specified %. I then enter, say
.97 into a cell - so as to achieve a 3% reduction - and then copy/paste
special/multiply across range. This will give me results that are not whole
integers, but it is whole integers that are needed. (I then go in and
manually change the range values to the whole integers that I need, and this
can sometimes be 100s of cells!)
Anyone got some brillant way of doing this? Many thanks in advance!

You could either write a VBA macro to accomplish this over a defined range of
cells.

Or, if you understand the consequences, you could consider formatting the
relevant cells to zero decimal places, and then setting Precision as Displayed
in the Options. This might have undesired consequences, so be sure you
understand them.
--ron

I think I understand the consequences, and that looks like it'll work for me!
Thank you!

"Ron Rosenfeld" wrote:

On Sun, 17 Jan 2010 17:16:02 -0800, Al wrote:

Is there a way to achieve such a roundup across a range of cells?
I understand =round(your_cell_reference,0) but that produces the rounded
value of, say A3 in, say, B3.
I often need to reduce a range of cells by a specified %. I then enter, say
.97 into a cell - so as to achieve a 3% reduction - and then copy/paste
special/multiply across range. This will give me results that are not whole
integers, but it is whole integers that are needed. (I then go in and
manually change the range values to the whole integers that I need, and this
can sometimes be 100s of cells!)
Anyone got some brillant way of doing this? Many thanks in advance!

You could either write a VBA macro to accomplish this over a defined range of
cells.

Or, if you understand the consequences, you could consider formatting the
relevant cells to zero decimal places, and then setting Precision as Displayed
in the Options. This might have undesired consequences, so be sure you
understand them.
--ron
.