I did find the Round functions but I also want to Round to the nearest 5 e.g.

281.326 should round to 381.35
302.320 should round to 302.30
4.675 should round to 4.70

Any ideas?

"Frank Kabel" wrote:

Also check out:
http://www.xldynamic.com/source/xld.Rounding.html

"Sho" wrote:

Is there a function that will round decimals to the nearest 10 e.g. if I had
62.675 I would want it to round to 63.