View Single Post
  #2   Report Post  
 
Posts: n/a
Default

JaneC wrote:
I have a list of values as below:
476.14
361.99
345.69
463.08
515.29
403.44
330.68
347.64
375.36
I would like to create a formula that rounds the values
to the nearest 0.05 eg. Round 476.14 to 476.15,
361.99 to 362.00, 375.36 to 375.35 etc...

MROUND(number, multiple)

For example, =MROUND(A1, 0.05)