Recreating formula from Excel Spreadsheet

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author codepeople

    (@codepeople)

    Hi,

    First, you should understand that our plugin is not a Excel emulator, so, cannot be used the same operations and operands.

    For example, assuming that:

    H3, is represented by the fieldname1 field in the form
    E3, is represented by the fieldname2 field in the form
    G3, is represented by the fieldname3 field in the form
    F3, is represented by the fieldname4 field in the form

    The equation would be:

    IF(fieldname1, '', IF(fieldname2 == 'back', fieldname3, (fieldname4-1)*fieldname3))

    Best regards.

    Thread Starter Stokie Worm

    (@chris_wareham)

    Thank you so much for the responce, i will work on the syntax you provided.

    jeanlondon12

    (@jeanlondon12)

    Hi, do you know how can add a conditional rule on the calculator like.
    Show this results if is greater than (field3)

    What I’m looking I have two types of pricing: Calculation 1 (Field1)*2.25 and Calculation 2 (Field2)*2.25

    Show this if the results of Calculation 2 is greater than Calculation 1

    Plugin Author codepeople

    (@codepeople)

    Hello,

    The equation would be simply:

    MAX(fieldname1,fieldname2)*2.25

    Best regards.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Recreating formula from Excel Spreadsheet’ is closed to new replies.