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 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