+ Reply to Thread
Results 1 to 4 of 4

A rounding query

  1. #1
    Registered User
    Join Date
    07-04-2007
    Posts
    5

    Question A rounding query

    I am trying to round a calculated number to the nearest 0.05.

    For example:
    091.78 = 091.80
    091.76 = 091.75

    For some reason, I can't for the life of me see a way of rounding this way
    but I feel there has to be a simple answer to this problem. Can anyone help?

    Thanks in advance!

    Jaypee

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    A rounding query

    If you have the Analysis ToolPak add-in installed...
    =MROUND(A1,0.05)

    Otherwise, try this:
    =ROUND(A1/0.5,1)*0.5

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    07-04-2007
    Posts
    5

    Talking Massive thanks

    Thank you Ron! I am wondering if there is a 'fastest answer' competition because your answer was there before I opened my email! Thanks very much. I don't have the add in as I am on a work computer so the 2nd option was perfect!

    Thanks again

    Jaypee

  4. #4
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    A rounding query

    Fastest Answer Competition?
    Nope....I probably noticed your question right after you posted it, thought of a possible solution... and my fingers felt like typing what I was thinking
    ...or...maybe there was a delay in emails being sent.

+ 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