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

Maybe:

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

Roundy wrote:

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

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

"Roundy" wrote:

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

Dumbo reply from me! Dave is correct.

"Toppers" wrote:

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

"Roundy" wrote:

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

Thank you so much!!!!

"Dave Peterson" wrote:

Maybe:

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

Roundy wrote:

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