Skip to main content
Question

Formula Help

  • March 14, 2017
  • 0 replies
  • 21 views
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
      This topic has been closed for replies.

      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
      • Quickbase Alumni
      • March 14, 2017

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


      Terms & ConditionsAccessibility statement