Formula with multiple conditions

  • Resolved mbhm1

    (@mbhm1)


    4 years, 11 months ago

    I am setting up a conditional formula with multiple conditions. Basically, the user enters their age in fieldname3, and in fieldname5 a value is determined based on that entered age (ie. if age is between 20 and 30, xx.x; else if between 30 and 40, yy.y; etc.) (the determined value is expected life until death, ie mortality rate). This is the conditional formula I am using, but it is not populating fieldname5:

    IF(fieldname3<30 AND fieldname3>=20, 55.8, IF(fieldname3<40 AND fieldname3>=30, 46.3, IF(fieldname3<50 AND fieldname3>=40, 36.8, IF(fieldname3<60 AND fieldname3>=50, 27.7, IF(fieldname3<70 AND fieldname3>=60, 19.3, IF(fieldname3<80 AND fieldname3>=70, 12.1, IF(fieldname3<90 AND fieldname3>=80, 6.5, 0)))))))

    Any help you can provide is greatly appreciated.

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

    (@codepeople)

    Hello @mbhm1

    In javascript the “AND” operator is represented by double ampersand symbols, so, the equation would be:

    
IF(fieldname3<30 && fieldname3>=20, 55.8, IF(fieldname3<40 && fieldname3>=30, 46.3, IF(fieldname3<50 && fieldname3>=40, 36.8, IF(fieldname3<60 && fieldname3>=50, 27.7, IF(fieldname3<70 && fieldname3>=60, 19.3, IF(fieldname3<80 && fieldname3>=70, 12.1, IF(fieldname3<90 && fieldname3>=80, 6.5, 0)))))))

    or using the “AND” operation distributed with the plugin:

    
IF(AND(fieldname3<30, fieldname3>=20), 55.8, IF(AND(fieldname3<40, fieldname3>=30), 46.3, IF(AND(fieldname3<50, fieldname3>=40), 36.8, IF(AND(fieldname3<60, fieldname3>=50), 27.7, IF(AND(fieldname3<70, fieldname3>=60), 19.3, IF(AND(fieldname3<80, fieldname3>=70), 12.1, IF(AND(fieldname3<90, fieldname3>=80), 6.5, 0)))))))

    Best regards.

    Thread Starter mbhm1

    (@mbhm1)

    That worked perfectly – thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Formula with multiple conditions’ is closed to new replies.