Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Round to nearest 5
Message
From
25/01/2005 08:34:17
 
 
To
25/01/2005 08:05:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00980330
Message ID:
00980357
Views:
28
Hilmar -- the one time I have an answer to anything in this forum, and somebody beats me to it!

>>Hi All,
>>
>>Having a bit of a brain freeze here...I have an integer between 0 and 100. I want to round it to the nearest integer wholly divisible by 5 i.e. 0,5,10,15,...95,100
>>
>>Sorry for the low quality challenge :)
>
>I am surprised by the complexity of some of the other solutions you received. Simply divide by 5, round, and then multiply by 5 again.
>
>
>? round(x / 5, 0) * 5
>
>
>This method would also work for fractions, e.g., round to the nearest 5 cents: replace 5 with 0.05.
>
>To round always down or always up, replace round() with ceiling() or floor().
>
>AFAIK, there is no built-in function to round to the "nearest whatever".
Jim Nelson
Newbury Park, CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform