View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default Round to the nearset 10th

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?


Ostensibly, that is what ROUND(A1, 1) does. You might need to format
as Currency with 2 decimal places to see $12.70

However, the question is: what do you want $12.85 to round to?

ROUND() will result in $12.90. But some people want $12.85 to round
down to $12.80, while $12.75 rounds up to $12.80 (so-called banker's
rounding).