Rounding and dropping digits
 

Hello,

Is there a way to round a number and than drop to only show a portion of it.
For example: 567,549 to appear as 568. Thank you.

Rounding and dropping digits
 

A1 = 567,549
=ROUND(A1,0)

If this post helps click Yes
---------------
Jacob Skaria


"Marissa" wrote:

Hello,

Is there a way to round a number and than drop to only show a portion of it.
For example: 567,549 to appear as 568. Thank you.

Rounding and dropping digits
 

=ROUND(A1,-3)

Custom format to #,##0,


Gord Dibben MS Excel MVP

On Wed, 22 Apr 2009 10:30:01 -0700, Marissa
wrote:

Hello,

Is there a way to round a number and than drop to only show a portion of it.
For example: 567,549 to appear as 568. Thank you.

Rounding and dropping digits
 

Thank you but it did not work. The result was the number in A1.

"Jacob Skaria" wrote:

A1 = 567,549
=ROUND(A1,0)

If this post helps click Yes
---------------
Jacob Skaria


"Marissa" wrote:

Hello,

Is there a way to round a number and than drop to only show a portion of it.
For example: 567,549 to appear as 568. Thank you.

Rounding and dropping digits
 

"Marissa" wrote:
Is there a way to round a number and than drop to only show
a portion of it. For example: 567,549 to appear as 568.

If you have 567,549 in one cell (A1) and you want 568 in another cell, you
can do:

=round(A1/1000,0)

Similarly, if you have a formula in a cell (A1) and you want to change the
formula so that it displays only thousands:

=round((formula)/1000,0)

The parentheses around "formula" may or may not be needed, depending on the
formula.

But if you want the cell value to remain 567,549 and only appear as 568, I
believe you need a formatting option to do that, and I am not aware of any
that does.

Rounding and dropping digits
 

Errata....

"JoeU2004" wrote:
But if you want the cell value to remain 567,549 and only appear as 568, I
believe you need a formatting option to do that, and I am not aware of any
that does.

Duh, what Gord wrote, namely the custom format

#,##0,

Note the comma at the end. I missed it when I read Gord's posting. Also,
no need to round to thousands first.


----- original message -----

"JoeU2004" wrote in message
...
"Marissa" wrote:
Is there a way to round a number and than drop to only show
a portion of it. For example: 567,549 to appear as 568.

If you have 567,549 in one cell (A1) and you want 568 in another cell, you
can do:

=round(A1/1000,0)

Similarly, if you have a formula in a cell (A1) and you want to change the
formula so that it displays only thousands:

=round((formula)/1000,0)

The parentheses around "formula" may or may not be needed, depending on
the formula.

But if you want the cell value to remain 567,549 and only appear as 568, I
believe you need a formatting option to do that, and I am not aware of any
that does.

Rounding and dropping digits
 

Marissa Sorry. Initially I read this as 567.549 instead of comma....

Gord has answered this..Cheers


If this post helps click Yes
---------------
Jacob Skaria


"Marissa" wrote:

Thank you but it did not work. The result was the number in A1.

"Jacob Skaria" wrote:

A1 = 567,549
=ROUND(A1,0)

If this post helps click Yes
---------------
Jacob Skaria


"Marissa" wrote:

Hello,

Is there a way to round a number and than drop to only show a portion of it.
For example: 567,549 to appear as 568. Thank you.