Formula Help

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
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"
Photo of STEPHANIE MILBURN

STEPHANIE MILBURN

  • 366 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,328 Points 50k badge 2x thumb
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)
Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb

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