Rounding to the nearest quarter point?

How do I round a calculation to the nearest quarter point. ie cell a1 + cell
a2 are added together with a result of 20.333. How do I get the cell b which
has the formula =a1+a2 show the result as 20.25?

Try =ROUND(A1/0.25,0)*0.25

It should work.

Hope that helps!

"George" wrote:

> How do I round a calculation to the nearest quarter point. ie cell a1 + cell
> a2 are added together with a result of 20.333. How do I get the cell b which
> has the formula =a1+a2 show the result as 20.25?

Thank you that worked, however two other questions.
Can the rounding be built into the result cell or the formula? Two how do I
rounfd another cell by 32's?


"dramajuana" wrote:

> Try =ROUND(A1/0.25,0)*0.25
>
> It should work.
>
> Hope that helps!
>
> "George" wrote:
>
> > How do I round a calculation to the nearest quarter point. ie cell a1 + cell
> > a2 are added together with a result of 20.333. How do I get the cell b which
> > has the formula =a1+a2 show the result as 20.25?

"George" <George@discussions.microsoft.com> wrote in message
news:F8CB66E7-ECD3-4644-B96A-CD7773249F5D@microsoft.com...
> How do I round a calculation to the nearest quarter point. ie cell a1 +
> cell
> a2 are added together with a result of 20.333. How do I get the cell b
> which
> has the formula =a1+a2 show the result as 20.25?

=MROUND(A1+A2,0.25)

Needs the Analysis ToolPak to be installed.
--
David Biddulph