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.

=round(a1*b1,-3)
*******************
~Anne Troy

www.OfficeArticles.com


"R Champ" <R wrote in message
...
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.

IF you just "need it to read" in thousands, you can format the cell to
do so. One way:

Format/Cells/Number/Custom #,##0,


In article ,
"R Champ" <R wrote:

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.

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