Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Dec 2003
    Location
    Clinton Twp., Michigan, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Roundup (Ecel 200 SP-2)

    I cannot get a cell to roundup to the next higher number when the number is between IE. 2.1 and 2.4. It rounds up 2.5 and higher to 3 but not lower. The help says it should but I can't get it to work. Any suggestion?

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

    Re: Roundup (Ecel 200 SP-2)

    With the number (2.1) in cell A1, one of these formulas should do it:
    =CEILING(A1,1)
    or
    =ROUNDUP(A1,0)

  3. #3
    New Lounger
    Join Date
    Dec 2003
    Location
    Clinton Twp., Michigan, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Roundup (Ecel 200 SP-2)

    Thanks for responding. I realized I left off some info in my previous post.
    My cell contains the following formula. I want the number displayed to be the next whole number.
    Basically I want a percentage of the calculation to be added to the total and then rounded up. This formula works if the number is 1.5 or higher. If it is 1.4 it shows 1. I want 2.

    =IF(I14>0,ROUNDUP(FY14/$GE14,)+((ROUNDUP(FY14/$GE14,)*$GD$13)),0)

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Roundup (Ecel 200 SP-2)

    Have you tried:

    =IF(I14>0,ROUNDUP(FY14/$GE14+FY14/$GE14*$GD$13,0),0)

    (It's hard to know what you have without knowing what's in the source cells.)
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    New Lounger
    Join Date
    Dec 2003
    Location
    Clinton Twp., Michigan, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Roundup (Ecel 200 SP-2)

    I tried your formula and it works great. Thanks for the help.

Posting Permissions

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