Rounding to nearest 1/16"

Good morning all!

I am a new user in Excel and I've used it very few time. Most I've done is add columns. I'm trying to figure out formulas and what not now. I'm actually using this for the business.

I have a function right now that goes like this:

=sqrt(cell^2+cell^2)

Its pythagorean theorem. It work but I want to round my answer off to the nearest 1/16" (closest up or down). I typed in this formula:

=mround(sqrt(cell^2+cell^2),0.0625)

It doesn't work obviously. But say my answer is 12.078125, I want it to round to 12.0625. Say my answer is 12.109375, I want it to round to 12.125.

If anyone needs more information I'll be glad to share it. I'll be asking a million questions on this forum and I tried using the search function and came up with nothing about rounding with fractions (that I could use).

Thank you so much!

Should work fine. You must have the Anaysis Toolpak installed to use MROUND and several other functions.

Tools > Add-Ins, ...

Awesome!! It did work after I loaded that ToolPak. Thank you for the quick and easy fix!

I'm sure I might have another question today...but thank you again!

You're welcome.

It would be more obvious to use

=mround(sqrt(cell^2 + cell^2), 1/16)