View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bigwheel bigwheel is offline
external usenet poster
 
Posts: 6
Default Round to the nearset 10th

How about =ROUND(A1,1)

"Ed" wrote in message
...
Hello, Im working with a currency where the smallest coin is $0.10, how do
I
set up a formula where if for example I get $12.71 it will round down to
$12.70 but if I get $12.76 it will round up to $12.80?

thanks!