Forum Discussion

STEPHANIEMILBU2's avatar
STEPHANIEMILBU2
Qrew Cadet
9 years ago

Formula Help

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
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    9 years ago
    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)
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    9 years ago

    [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.