Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Round up formula (Excel XP)

    Is there a formula I can use to round up a number For example 1.21 would round to 2 instead of with the round function which would retun 1..
    Jerome

  2. #2
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Round up formula (Excel XP)

    =CEILING(A1,1)
    Microsoft MVP - Excel

  3. #3
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Round up formula (Excel XP)

    Anpther option to Ceiling is the Excel function called Roundup which does what exactly you want. See the Excel help topic for the syntax and options. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>
    Paul Coyle
    Approach love and cooking with reckless abandon

  4. #4
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Round up formula (Excel XP)

    Many thanks to all, Out of curiousity why the 2 functions, any real difference or use??

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Round up formula (Excel XP)

    CEILING(a,n) rounds a up to the nearest higher multiple of n, for example CEILING(2.33,0.05) returns 2.35 and CEILING(2.33,1) returns 3.

    ROUNDUP(a,n) rounds a up to n decimals, for example ROUNDUP(2.33,1) returns 2.4

  6. #6
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Round up formula (Excel XP)

    many thanks for the education
    Jerome

  7. #7
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Round up formula (Excel XP)

    =round(a1+0.5,0) where a1 contains the target number also works:
    1.21 2
    3.89 4
    568.3 569
    457825.7 457826
    but this one may not be what you had in mind!
    4 5

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •