How can I use round to ALWAYS round up?

# Thread: How can I use round to ALWAYS round up?

1. malbs Guest

## How can I use round to ALWAYS round up?

Is there any way to always make sure when I round a number (say 25.23), it rounds up to 26?<BR><BR>Round seems to drop it down to 25 (as it should I guess), however, I need it to always round up to the next number

2. David Moran Guest

## RE: How can I use round to ALWAYS round up?

&nbsp;<BR>x = roundUp(x)<BR>function roundUp(x)<BR> remainder = x-Abs(x)<BR> if remainder &#062; 0 then<BR> x = x+1<BR> end if<BR> round=x<BR>end function<BR>

3. David Moran Guest

## RE: How can I use round to ALWAYS round up?

Sorry the function should assign roundUp not round<BR><BR>x = roundUp(x) <BR>function roundUp(x) <BR> remainder = x-Abs(x) <BR> if remainder &#062; 0 then <BR> x = x+1 <BR> end if <BR> roundUp=x <BR>end function <BR>

4. malbs Guest

## RE: How can I use round to ALWAYS round up?

Thanks! :)

5. Dudley M Guest

## RE: How can I use round to ALWAYS round up?

y = RoundUp( x)<BR><BR>Function RoundUp( x)<BR> RoundUp = Fix( x) + 1<BR>End Function<BR>

#### Posting Permissions

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