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 {F...
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)