Thread
:
Rounding to the nearest 9th
View Single Post
#
9
Ron Rosenfeld
Posts: n/a
On Thu, 7 Apr 2005 09:39:01 -0700, "David S" <David
wrote:
Want to add to what Corby wrote.
I would like the same thig, but I would like Excel to round up or down.
Example:
1.21 becomes 1.19
1.35 becomes 1.39
1.34 becomes 1.29
Perhaps:
=ROUND(A1+0.005,1)-0.01
--ron
Reply With Quote