Mround function equivalent that does not require "add-in"

[Guest]

I am working on a spreadsheet that will be distributed to a group of about
100 people with varying degrees of computer knowledge. I need to do rounding
to the nearest 1/4 inch. I was going to use mround function for this...but
when I first tried it I got "name?" in the result box. I was able to find
that I needed to enable the formula analysis toolpak...but I am not
comfortable putting this responsibility on "novice" users. Is there another
function I could use to accomplish the same task without having to walk users
through enabling addins or another suggestion for how to accomplish this.
Thank you in advance for the help.

Jonathan

 

[Dave Peterson]

Maybe:

=ROUND(A1*4,0)*0.25
or
=ROUND(A1/0.25,0)*0.25

 

[Guest]

Try format cell as NUMBER ==>FRACTIONS==>As quarters

 

[Guest]

Dumbo reply from me! Dave is correct.

Try format cell as NUMBER ==>FRACTIONS==>As quarters

 

[Guest]

Thank you so much!!!!

Maybe:

=ROUND(A1*4,0)*0.25
or
=ROUND(A1/0.25,0)*0.25