Closed Thread
Results 1 to 5 of 5

mround fuction not working

  1. #1
    Registered User
    Join Date
    01-14-2011
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    5

    mround fuction not working

    Hi All,

    I am having a problem using the mround function. I would like to round a given number to the nearest multiple of 5 using the formula below:

    Please Login or Register  to view this content.
    When i do this, I get the following error message:

    #NAME?

    I have tried this formula on a collegues computer using the same workbook and it works correctly.

    Is there a reason why this isn't working on my computer?

    Thanks,

    Graeme

    PS. using excel 2003 sp2

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: mround fuction not working

    MROUND is part of the Analysis ToolPak pre XL2007 - you must activate this Add-In via Tools -> Add-Ins

    Non ATP version would be:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-14-2011
    Location
    Scotland
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: mround fuction not working

    Thanks for your help, worked a treat.

    Graeme

  4. #4
    Registered User
    Join Date
    03-23-2012
    Location
    Malibu, California
    MS-Off Ver
    Excel 2007
    Posts
    39

    Re: mround fuction not working

    Hi,

    I've got a vexing situation when using the mround function. I am utilizing the following formula:

    =mround(average(g$2:g$4),0.05)

    and receiving "#num" error messages. After trouble-shooting extensively, it appears that the formula works when the result is a positive number; it brings up the "#num" error message when the result is a negative number.

    This seems to me to be retarded. How is it that Excel cannot deal with negative numbers? Is my version buggy, or does someone know a fix within the syntax of the formula? All help will be mucho appreciado.

  5. #5
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: mround fuction not working

    DPKologie,

    Welcome to the Forum, unfortunately:

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed 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