Use excel formula (GRAD)

  • Resolved scc2452555

    (@scc2452555)


    2 years ago

    Hello,

    i want to use this Excel formula in a calculated field: =SUMME(GRAD(ARCSIN(N3/N4)))

    N3/N4 should be fieldname2 and fieldname3

    Can you please help me writing this formula that it works in the plugin? I dont find the GRAD Function in the plugin. Thank you for your help.

    Greets

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    2 years ago

    Hello @scc2452555

    Thank you very much for using our plugin.

    Our plugin includes many operations that satisfy some Excel functions, but it is not an Excel interpreter or emulator. You must implement the equations using the plugin operations, or JS.

    The Excel formula =SUMME(GRAD(ARCSIN(N3/N4))) where N3 and N4 correspond to the fieldname2 and fieldname3 fields in the form can be implemented as follows:

    Insert a calculated field in the form and enter the following equation through its “Set equation” attribute:

    DEGREES(ASIN(fieldname2/fieldname4))

    Note I don’t include the equality symbol in front the equation.

    Best regards.

Viewing 1 replies (of 1 total)

The topic ‘Use excel formula (GRAD)’ is closed to new replies.