how do I round numbers in .125 increments
how do I round numbers in .125 increments
Increments? Are you rounding up or do you want to round to the nearest
0.125?
for the latter
=ROUND(A1/0.125,0)*0.125
for the former
=CEILING(A1,0.125)
--
Regards,
Peo Sjoblom
Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey
"dave" <[email protected]> wrote in message
news:[email protected]...
> how do I round numbers in .125 increments
>
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?
"caryd" <[email protected]> wrote in
message news:[email protected]...
>
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks