logical calculator

  • Resolved rolino

    (@rolino)


    3 years, 2 months ago

    how to transform this into logical calcution on Calculated Fields Form

    “SI(A2=”dropdown1″;SI(B2=”dropdown2″;SI(I2<6;H2*O2*1,4;O2*I2);SI(I2<6;H2*O2;I2*O2));SI(I2<6;H2*O2;I2*O2))”

    thanks

    The page I need help with: [log in to see the link]

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

    (@codepeople)

    Hello @rolino

    The solution is similar, only keep in mind the operator for equality in javascript is the double symbol ==, and the separator between operands in the comma symbol (,) instead of the semicolon.

    So, assuming the cells:

    A2 corresponds to the fieldname1
    B2 to the fieldname2
    I2 to the fieldname3
    H2 to the fieldname4
    O2 the fieldname5

    The equation would be similar to:

    IF(fieldname1=="dropdown1",IF(fieldname2=="dropdown2",IF(fieldname3<6,fieldname4*fieldname5*1.4,fieldname5*fieldname3),IF(fieldname3<6,fieldname4*fieldname5,fieldname3*fieldname5)),IF(fieldname3<6,fieldname4*fieldname5,fieldname3*fieldname5))

    Note that the decimal symbol in javascript is the point and not the comma (1.4)

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘logical calculator’ is closed to new replies.

Tags