Rounding

  • Thread starter Thread starter Crystal Lee
  • Start date Start date
C

Crystal Lee

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

For example,
17551 to 17550
16284 to 16280
22135 to 22140
 
Try the below

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

If this post helps click Yes
 
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
 
Thanks for your reply. But is it possible to do the same thing by edit the
cell format (ie without adding formula)?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round formula 1
Problem with Rounding (2007) 4
Round up or down by set variable 3
Don't Round... 7
Summing VLookup from a variable number of sheets 4
Formula Help 1
12 digit number rounding down why? 5
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1

Back
Top