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).
|