Discussions

Expand all | Collapse all

Formula Help

  • 1.  Formula Help

    Posted 03-14-2017 19:13
    Formula that goes {Field 1}="Installed" and [Field 2] = "No" then [field 3] equals "$5,000". However if {Field 1}="Not Installed" and [Field 2] = "No" then [field 3] equals "$10,000", and lastly if {Field 1}="Installed" and [Field 2] = "Yes" then [field 3] equals "$0


  • 2.  RE: Formula Help

    Posted 03-14-2017 19:17
    Try this as a formula Numeric field type called [Field 3]

    IF(
    [Field 1]="Installed" and [Field 2] = "No", 5000,
    [Field 1]="Not Installed" and [Field 2] = "No", 10000,
    [Field 1]="Installed" and [Field 2] = "Yes" ,0)


  • 3.  RE: Formula Help

    Silver
    Contributor
    Posted 03-14-2017 19:18

    [Field 3] formula numeric 

    ===

    if(

    [Field 1]="Installed" AND [field 2]="No", 5000,

    [Field 1]="Not Installed" AND [Field 2]="No",10000,

    [field 1]="Installed" AND [Field 2]="Yes", 0,null

    )

    The null is the default if all conditions are false.