Rounding
 

How can I round a number by editing the cell format?

For example,
17551 to 17550
16284 to 16280
22135 to 22140

Rounding
 

Try the below

=IF(MOD(A1,10)4,CEILING(A1,10),FLOOR(A1,10))

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


"Crystal Lee" wrote:

How can I round a number by editing the cell format?

For example,
17551 to 17550
16284 to 16280
22135 to 22140

Rounding
 

You can also use MROUND() which returns a number rounded to the desired
multiple.

=MROUND(A1,10)

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in...menu ToolsAdd-Ins check Analysis ToolPak

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


"Crystal Lee" wrote:

How can I round a number by editing the cell format?

For example,
17551 to 17550
16284 to 16280
22135 to 22140

Rounding
 

Thanks for your reply. But is it possible to do the same thing by edit the
cell format (ie without adding formula)?

"Jacob Skaria" wrote:

You can also use MROUND() which returns a number rounded to the desired
multiple.

=MROUND(A1,10)

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in...menu ToolsAdd-Ins check Analysis ToolPak

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


"Crystal Lee" wrote:

How can I round a number by editing the cell format?

For example,
17551 to 17550
16284 to 16280
22135 to 22140

Rounding
 

=ROUND(A1,-1)
Can't be done with format.
--
David Biddulph

"Crystal Lee" wrote in message
...
How can I round a number by editing the cell format?

For example,
17551 to 17550
16284 to 16280
22135 to 22140

Rounding
 

thanks for your help~

"David Biddulph" wrote:

=ROUND(A1,-1)
Can't be done with format.
--
David Biddulph

"Crystal Lee" wrote in message
...
How can I round a number by editing the cell format?

For example,
17551 to 17550
16284 to 16280
22135 to 22140

Rounding
 

Cannot..

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


"Crystal Lee" wrote:

Thanks for your reply. But is it possible to do the same thing by edit the
cell format (ie without adding formula)?

"Jacob Skaria" wrote:

You can also use MROUND() which returns a number rounded to the desired
multiple.

=MROUND(A1,10)

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in...menu ToolsAdd-Ins check Analysis ToolPak

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


"Crystal Lee" wrote:

How can I round a number by editing the cell format?

For example,
17551 to 17550
16284 to 16280
22135 to 22140