• #### Round up

From Joe taniart@21:1/5 to All on Thu Oct 18 20:40:52 2018
Hi,

I have problems on round up a number as below :

Value Result
18 20
47 50
13 20

From excel I use the roundup(value,-1) to have the result. how about at clarion, what formula should I use ?

thanks,

Joe

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
• From Leonid Chudakov@21:1/5 to Joe Drive on Fri Oct 19 00:05:36 2018
disregard the previous one
NewValue = CHOOSE(ROUND(Value,10)<Value,ROUND(Value,10)+10,ROUND(Value,10))

On Friday, October 19, 2018 at 6:40:53 AM UTC+3, Joe Drive wrote:
Hi,

I have problems on round up a number as below :

Value Result
18 20
47 50
13 20

From excel I use the roundup(value,-1) to have the result. how about at clarion, what formula should I use ?

thanks,

Joe

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
• From Leonid Chudakov@21:1/5 to Joe Drive on Fri Oct 19 00:01:21 2018
ROUND(Value,10)

On Friday, October 19, 2018 at 6:40:53 AM UTC+3, Joe Drive wrote:
Hi,

I have problems on round up a number as below :

Value Result
18 20
47 50
13 20

From excel I use the roundup(value,-1) to have the result. how about at clarion, what formula should I use ?

thanks,

Joe

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
• From Sean H@21:1/5 to Joe taniart on Sat Oct 20 16:30:41 2018
On 19/10/18 13:40, Joe taniart wrote:
Hi,

I have problems on round up a number as below :

Value Result
18 20
47 50
13 20

From excel I use the roundup(value,-1) to have the result. how about at clarion, what formula should I use ?

thanks,

Joe

I think ROUND(Value+5,10) might work (untested)

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
• From Joe Tan@21:1/5 to All on Sat Oct 20 23:59:01 2018
Great thx a lot

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)