how do I round numbers in .125 increments
"caryd" wrote in
message ...
I posted under another topic too but then found this one to more closely
match what I'm trying to do.
I have a formula already in the cells I want to round to the nearest
.125
X is the column I'm wanting to round up, however I already have a
formula in X2 which is T2+U2=X2.
How can I get the whole column formatted for =CEILING(A1,0.125) without
loosing my original formula?
=CEILING(T2+U2,0.125)
but note that this doesn't round to the *nearest* .125, but to the value
above.
You may want MROUND() if you want the nearest.
--
David Biddulph
|