Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Round up if (2003)

    Hi - need to force Excel to roundup to the next whole integer if the result of a simple division formula is *.45 or higher and to round down if the result is lower. Have attached a small sample - thanks in advance - again.

    Aunt Linda

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Round up if (2003)

    Modified:
    I yield to Legare's much more elegant solution. I suspect that you don't want decimal places; if so Legare's formula would be:
    =ROUND(A1+.05,0)
    Regards
    Don

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Round up if (2003)

    Thank you again - and, again, works just fine.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Round up if (2003)

    It really does work - but I sure appreciate your response as well. It's soooooooo nice to know there are smart people out there who can help me!

    Again - thanks

    Aunt Linda

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Round up if (2003)

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15> OOPS, Fat fingers.

    Thanks. Off to correct my post.
    Legare Coleman

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Round up if (2003)

    If the value is in A1, will this do what you want:

    =ROUND(A1+.05,0)

    Corrected - Thanks to Don
    Legare Coleman

Posting Permissions

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