Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Rounding up & down

1 view
Skip to first unread message

alecgreen

unread,
Oct 10, 2006, 6:43:04 AM10/10/06
to
Is it possible to round up or down numbers in a column to the nearest 5
or 0. For example
872 = 870, 1056 = 1060.


Many Thanks

Alec

Karitaat

unread,
Oct 17, 2006, 8:13:23 AM10/17/06
to
Alec,

5 * INT((X + 2.5) / 5)

That rounds 872 to 870; 874 to 875 but 1056 to 1055 (and NOT 1060)

Hope that helps.

regards,
Karitaat


alecgreen schreef:

0 new messages