View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Round to the nearset 10th

ROUND(A1,1)

"Ed" wrote:

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!