# Thread: Roundup (Ecel 200 SP-2)

1. ## 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. ## 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. ## 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. ## 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.)

5. ## 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
•