Rounding to the nearest quarter point?

G

George

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?
 
D

David Biddulph

George said:
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.
 
G

George

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top