How to round number to the nearest multiple of signifiance?

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
 
S

Stefan Hägglund [MSFT]

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 time to nearest 15 minutes in decimal format 4
rounding up to nearest specified whole number 1
Round Down to the nearest multiple 2
ROUNDING UP TO NEAREST 9 4
how to multiply two values and round the result 5
Rounding to nearest 50 pence 1
How can you round a number to the nearest 900? 17
How do I round a number to the nearest 900? 1

Top