Round function - round to 5

  • Thread starter Thread starter freimc
  • Start date Start date
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
 
-----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)
 
Back
Top