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!

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

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!

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!