+ Reply to Thread
Results 1 to 10 of 10

Divide a number by 32 then get the value to round to the nearest .5

Hybrid View

  1. #1
    Registered User
    Join Date
    02-13-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Divide a number by 32 then get the value to round to the nearest .5

    Thanks for that - I tried to use the same formula in another cell as follows but it rounds down

    Value in cell is 135 and it needs to be divided by 50, it gives an answer of 2.7 if I do it manually but when I use the formula below it rounds down and not up

    MROUND(J6/50,0.5)
    it gives the value of 2.5 but manual calculation gives a value of 2.7 so it needs to round up to 3
    is there a formula that will set this to always round up to the nearest half

    thanks

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,234

    Re: Divide a number by 32 then get the value to round to the nearest .5

    try

    MROUND(J6/50 + 0.5, 0.5)
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    02-13-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: Divide a number by 32 then get the value to round to the nearest .5

    Thank you so much the ceiling worked a treat.
    Last edited by KazzICC; 07-01-2014 at 01:03 AM.

+ 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. Round number to nearest .05
    By gail.wiley in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-31-2014, 05:52 PM
  2. Round a number to the Nearest .25
    By Dave E in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  3. [SOLVED] Round a number to the Nearest .25
    By Dave E in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  4. Round a number to the Nearest .25
    By Dave E in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  5. [SOLVED] Round a number to the Nearest .25
    By Dave E in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-29-2005, 11:05 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