How to make a number round up/down to a set number

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

David,

For a number in cell A1

=ROUND(A1,1) -0.01

HTH,
Bernie
MS Excel MVP


"David S" <David [email protected]> wrote in message
news:[email protected]...
> 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