Rounding

[Crystal Lee]

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

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

 

[Jacob Skaria]

Try the below

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

If this post helps click Yes

 

[Jacob Skaria]

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 Tools>Add-Ins> check Analysis ToolPak

If this post helps click Yes

 

[Crystal Lee]

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

 

[David Biddulph]

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

 

[Crystal Lee]

thanks for your help~

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

 

[Jacob Skaria]

Cannot..

If this post helps click Yes