How to round number to the nearest multiple of signifiance?

  • Thread starter Thread starter Air2000
  • Start date Start date
A

Air2000

I have entered the formula in my cell, and I want my result to be rounded to
the nearest multiple of signifiance (for example 5). I have tried with
function CEILING and FLOOR, but these functions only rounds number
UP(ceiling) or DOWN(floor), so for this I have to know what my result is to
rounded it. That is not the solution, I would like for Excel to do it
automaticaly. Here is example:

If my result is say 117.49 and lower (to the limit of 115), I want to round
it to 115, if result is 117.51 and higher (to the limit of 120) to round to
120...(multiple of significance is 5).

Can it be done?

Rgds
 
Hi!

You can use the formula below, if you activate the Analysis Toolpak (Tools,
Add-ins, check Analysis Toolpak)
=MROUND(A1,5)


Best regards

Stefan Hägglund
Microsoft
 

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 to nearest multiple 3
rounding up to nearest specified whole number 1
Rounding to nearest 50 pence 1
Round Down to the nearest multiple 2
ROUNDING UP TO NEAREST 9 4
Rounding up or down to nearest whole number 1
Round time to nearest 15 minutes in decimal format 4
Average rounded to nearest 0.50 4

Back
Top