"R Champ" wrote:

What I meant to say is - I need to have the result read in thousands but use
the number found in millions.

Example, my formula result is 521,689,745.04 I need the cell to read
521,690. I need to take away more then just the two decimal places. I need
to take away the two decimal places plus the next three places and round up.


I need to rounddown a formula result from millions to thousands i.e. result
is 451,321,589 to need it to read 451,322.