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.