Round function - round to 5

F

freimc

I'm trying to round to 5 but can't figure it out. Decimals are clear, s
is round(xx, -1)... but:
26 should be 25
27 should be 25
28 should be 30 etc.
Any ideas? Thank you very much in advance
 
G

Guest

-----Original Message-----
I'm trying to round to 5 but can't figure it out. Decimals are clear, so
is round(xx, -1)... but:
26 should be 25
27 should be 25
28 should be 30 etc.
Any ideas? Thank you very much in advance!
Click to expand...

USE THE FUNCTION =MROUND(XXX,5)
 

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 it off 3
ROUNDED NUMBERS 4
Rounding results by ranges 3
Round up or down to nearest 5, but not 10 2
How do I have excel highlight days before & after a date on a cale 2
formula/version 2007 2
Outlook 2010 can't find .pst file 2
Additions of Round Function and Minus Sign at Once 7

Top