Rounding Numbers in Excel


  1. Sven1458
    Posts : 331
    windows 10
       New #1

    Rounding Numbers in Excel


    My Boss wants me to round numbers to the nearest 100.

    Example: 3624 should read 3600
    3659 should read 3700

    any one know what the formula is to do this?
    Thanks for helping

    I am running office 2019
      My Computer
    Quote Quote

  3. steve108
    Posts : 21,421
    19044.1586 - 21H2 Pro x64
       New #2

    Hello Sven,
    See this: Excel Round to Nearest 100 (6 Quickest Ways) - ExcelDemy
      My Computer
    Quote Quote

  4. Sven1458
    Posts : 331
    windows 10
    Thread Starter
       New #3

    Thanks
      My Computer
    Quote Quote

  6. cereberus
    Posts : 15,494
    Windows10
       New #4

    Sven1458 said:
    My Boss wants me to round numbers to the nearest 100.

    Example: 3624 should read 3600
    3659 should read 3700

    any one know what the formula is to do this?
    Thanks for helping

    I am running office 2019
    Assume number in cell A1
    =int(a1/100 +0.5)*100
      My Computer
    Quote Quote

 

  Related Discussions
Hello All, I ask your support on this issue: I often open excel files sent by cistomers/suppliers, etc... with formulas. When I open those in my Excel 2013 the formulas are not working, and instead are wrapped by curly brackets {formula} the...
If you try to tie a image to a cell in excel and then you link that image to its file. Excel because the image was embedded in the cell it will change the hyperlinks on you. but if you just link a image to text in a cell I do not believe excel will...
Numbers before URL
in Chillout Room

Been re-indexing some saved pages and bookmarks/favorites and noticed the (x) number at the beginning of the saved-file name and the URL in the Address bar, have to be sure to remove it before saving so as to have things lined up alphabetically. ...
Excel 2010 I have a column of 22,000 phone numbers (and an additional column of fax numbers). I'm trying to convert the numbers from nine digits to nine digits with hyphens. I copied and renamed the original document. There are no...
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 15:05.
Find Us




Windows 10 Forums