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

D

David S

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
 
B

Bernie Deitrick

David,

For a number in cell A1

=ROUND(A1,1) -0.01

HTH,
Bernie
MS Excel MVP
 
Top