rounding

[BRM108]

Good Morning,
I would like some help with a function that can round a number such as $2,064,584 to $2,065.
Thanks.

 

[prabby25101981]

How many digits do you want in the final number? If you want 4 digits, then here's the formula -

=ROUND(A13/LEFT(CONCATENATE(1,"0000000"),4),0)

Format it in currency...

 

[PA HS Teacher]

Perhaps:
=ROUND(A1,-3)/1000

Alternatively, you could go change the number format to custom and enter:
$0,000,

though the underlying number would still have all of the digits, it would just display as desired.

 

[BRM108]

Thank you so much! Great responses! Very helpful!

 

[artvandelay]

Mround would work too, plus it might make your formula a little bit simpler