IF Statement Help!

  • Resolved aslante

    (@aslante)


    7 years, 9 months ago

    I am trying to do a nested IF function but I can’t seem to get it to work:

    IF( fieldname7=0, “0”, IF( fieldname7<=2, (fieldname7*550+300), (fieldname7*550)))

    I tried this in Excel and it works, so I’m not sure what is wrong.

    Any advise will be great!

    • This topic was modified 7 years, 9 months ago by aslante.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    7 years, 9 months ago

    Hello @aslante,

    The issue is simple, in javascript the operator for equality is the double sign: “==” because the sign: “=” is used for assignment, so, the equation should be fixed as follows:

    
IF(fieldname7==0, 0, IF(fieldname7<=2, fieldname7*550+300, fieldname7*550))

    I’ve removed the unnecessary parentheses and double quote symbols.

    Best regards.

    Thread Starter aslante

    (@aslante)

    7 years, 9 months ago

    @codepeople

    Works perfectly! thank you! “D

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘IF Statement Help!’ is closed to new replies.