View Single Post
  #1   Report Post  
JaneC
 
Posts: n/a
Default Rounding Numbers

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€¦
Is there anyway that I can do this?

Thanks, Jane.