+ Reply to Thread
Results 1 to 4 of 4

Roundup

  1. 04-24-2014, 10:11 PM #1
    mahershams
    mahershams is offline
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Roundup

    Dear Excel forum
    Please help me to roundup the value in B2 cell. I provide you the manual output.

    Regards
    Shams
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-24-2014, 10:55 PM #2
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Roundup

    Perhaps this one

    =CEILING(A3,0.5)

    and copy formula down
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne
    Reply With QuoteRegister To Reply
  3. 04-25-2014, 01:00 AM #3
    mahershams
    mahershams is offline
    Forum Contributor
    Join Date
    11-24-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    225

    Re: Roundup

    Thank you so much for help.
    Reply With QuoteRegister To Reply
  4. 04-25-2014, 08:09 AM #4
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Roundup

    You're welcome and thank you for the feedback!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. roundup
    By Wallace38 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2007, 03:04 PM
  2. Roundup
    By rdaled in forum Excel General
    Replies: 1
    Last Post: 01-05-2007, 03:52 PM
  3. Roundup to .99
    By mj99 in forum Excel General
    Replies: 2
    Last Post: 11-15-2006, 03:07 PM
  4. roundup
    By david.madden in forum Excel General
    Replies: 6
    Last Post: 10-27-2006, 08:24 AM
  5. [SOLVED] roundup by 16s
    By Sum Limit and marking in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2006, 10:30 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1