Rounding to the nearest quarter point?
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?
|