[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Re: rounding to nearest 1000

Bernard Liengme

12/18/2006 2:06:00 PM

=ROUND(A1,-3)

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"walt" <walt@discussions.microsoft.com> wrote in message
news:AF110F85-5A72-450D-AEB4-DA325F218F0A@microsoft.com...
>I have a permit formula that needs to have any input numbers rounded to the
> nearest 1000
>
> Thanks
>
> PS sorry for the last post hit the enter key to fast