Subject |
Re: Convertion |
From |
Mervyn Bick <invalid@invalid.invalid> |
Date |
Fri, 03 Jul 2015 17:16:24 +0200 |
Newsgroups |
dbase.getting-started |
On Fri, 03 Jul 2015 10:38:41 +0200, Mervyn Bick <invalid@invalid.invalid>
wrote:
> int(num/5)*5 will give you the converted values that you show. These
> are not the "nearest" but rather the "highest lower" values that end in
> 0 or 5.
>
> The "nearest" to 43 would be 45. To convert to the "nearest" value
> ending in 0 or 5 use
>
> iif(mod((num/10-int(num/10))*10,5)>=3,(int(num/5)*5)+5,int(num/5)*5)
Once again Ivar has shown me a bette way. :-)
iif(num%5>=3,int(num/5)*5+5,int(num/5)*5)
Mervyn.
|
|