1. Forum
  2. Usenet
  3. COMP.LANG.CLARION

  • 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)