Roundup

  • Resolved stefanig

    (@stefanig)


    4 years, 6 months ago

    Hello,

    I am using CFF for one project.
    And I want to ask you, something. What is the equivalent of a roundUp in excel in that of CFF.
    I have a formula like “=ROUNDUP(F10*(K24+4,5*(C14/1,6)+15*C14/13);-1)”, output is => 480.00 and when I remove roundUp and the result is => 477,64
    Can you explain me how it works, what is the equivalent and etc..

    Thank you,
    Best wishes! ??

    • This topic was modified 4 years, 6 months ago by stefanig.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @stefanig

    The equivalent in our plugin would be the CEIL operation.

    So, assuming that:

    F10 is the fieldname1
    K24 the fieldname2
    C14 the fieldname3

    The equation associated to the calculated field would be:

    
CEIL(fieldname1*(fieldname2+4.5*fieldname3/1.6+15*fieldname3/13))

    Best regards.

    Thread Starter stefanig

    (@stefanig)

    Thank you ! ??

    What about if roundup is -2?
    example: =ROUNDUP(….;-2)

    Plugin Author codepeople

    (@codepeople)

    Hello @stefanig

    In this case the operation would be:

    
CEIL(X, 10)

    Best regards.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Roundup’ is closed to new replies.