View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

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