format numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lmossolle - 24 Mar 2008 17:35 GMT

Is there anyway to round up to the next highest number using the following?

=Sum([daystoaward]/[awarddays])

Thanks

Reply to this Message

akphidelt - 24 Mar 2008 17:51 GMT

Not sure if this works but try

Int(Sum([daystoaward]/[awarddays]))+1

> Is there anyway to round up to the next highest number using the following?
>
> =Sum([daystoaward]/[awarddays])
>
> Thanks

Reply to this Message

John Spencer - 24 Mar 2008 18:57 GMT

The following should round up to the next integer value. If the result is
already an integer then it will not increase the sum

= - Int (- Sum([daystoaward]/[awarddays]))

1.1 --> 2
1 --> 1

Negative numbers will also round by they will round towards zero so you will
get
-5.5 --> -5

Signature

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
.

> Is there anyway to round up to the next highest number using the
> following?
>
> =Sum([daystoaward]/[awarddays])
>
> Thanks

Reply to this Message