+ Reply to Thread
Results 1 to 3 of 3

Rounding near to 1000

  1. #1
    Registered User
    Join Date
    07-16-2011
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    15

    Rounding near to 1000

    I have a sheet of figures e.g. 835,765. The formula I need that should see the figure after the "," if it is greater than 499 then the figure before the "," should be "figure+1" and after the "," it should change to "000" and

    if the figure after the "," is less than 500 then it should keep the figure before "," as it is and after the "," it should be "000".

    For Example:

    If 835,765............ it should be 836,000 and
    If 835,365............ it should be 835,000

    Thanks & regards,

    Shakeel Ahmad.
    Shakeel Ahmad
    www.facebook.com/shakeelahmad215

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Rounding near to 1000

    hi there. how about:
    =ROUND(A1,-3)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    07-16-2011
    Location
    Lahore, Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Rounding near to 1000

    Thank you, it worked.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] rounding up a cell to closest 1000 but also if cell is less than 0 to show 0.
    By Bett in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-08-2014, 01:19 PM
  2. Custome Formatting Rounding to the Nearest 1000
    By MichaelCallahan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-03-2013, 07:08 AM
  3. rounding to 1000
    By Jaakkolo in forum Excel General
    Replies: 1
    Last Post: 08-27-2012, 06:22 AM
  4. Replies: 5
    Last Post: 09-20-2011, 07:39 AM
  5. Rounding up to next 1000
    By LTUser54 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2008, 12:17 PM
  6. 1000+$K$5/1000 -what does $ indicate in formula
    By Coolbhims in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-16-2006, 07:55 AM
  7. rounding nearest 1000
    By SMILE in forum Excel General
    Replies: 2
    Last Post: 04-06-2005, 01:20 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1