Thread
:
How to make a number round up/down to a set number
View Single Post
#
2
Bernie Deitrick
Posts: n/a
David,
For a number in cell A1
=ROUND(A1,1) -0.01
HTH,
Bernie
MS Excel MVP
"David S" <David
wrote in message
...
i would like to have a set of prices round up or down to the nearest
ninth.
for example, 1.15 turns into 1.19. 2.41 turns into 2.39
Reply With Quote