+ Reply to Thread
Results 1 to 3 of 3

Rounding off Decimal Digits only

Hybrid View

sujittalukder Rounding off Decimal Digits... 03-13-2011, 06:38 AM
daddylonglegs Re: Rounding off Decimal... 03-13-2011, 06:50 AM
sujittalukder Re: Rounding off Decimal... 03-13-2011, 07:02 AM
  1. #1
    Registered User
    Join Date
    04-11-2007
    Posts
    49

    Rounding off Decimal Digits only

    Dear experts,
    I want a formula which will round off the decimal digits in multiples of 0.05 or 0.00 based on criteria.For eg,
    If the Number is, Excel formula should round off as
    7.60,7.60
    7.61,7.60
    7.62,7.60
    7.63,7.65
    7.64,7.65
    7.65,7.65
    7.66,7.65
    7.67,7.65
    7.68,7.70
    7.69,7.70
    7.70,7.70

    Thus the logic is:
    If the Unit place of decimal digit is between 0 to 2 then Round off in mulatiple of 0 (Zero)
    If the Unit place of decimal digit is between 3 to 7 then Round off in mulatiple of 0.05 (Zero)
    If the Unit place of decimal digit is greater than 0, then Round off in mulatiple of next higher 0 (Zero) level ie 7.68 becomes 7.70, 7.88 becomes 7.90, 7.98 becomes 8.00 and so on like this.

    How can this be done with formula?
    Youe help will really benefit me a lot.

    Thanks and regards
    Sujit Talukder

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,695

    Re: Rounding off Decimal Digits only

    You can use MROUND function

    =MROUND(A1,0.05)

    In versions of Excel 2003 or before you need to activate Analysis ToolPak add-in for MROUND so an alternative is

    =ROUND(A1*2,1)/2

    where your number is in A1
    Audere est facere

  3. #3
    Registered User
    Join Date
    04-11-2007
    Posts
    49

    Re: Rounding off Decimal Digits only

    Thank you daddylonglegs,
    Many Many thanks.
    Its so simple and I wasted last 1 day to come out with solution.

    Once again, thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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