I currently have 3 fields that i am adding to gether in a formula
[Other Savings Field 2.1]+[Other Savings Field 2.2]+[Other Savings Field 2.3] now if i wanted to add Other savings 1.1 to it conditionally. How would i go about writing a formula like that. My thought was to maybe have a checkbox to add to total but woudl that work? How would the formula work? Or is there a different way to have that field added to total?
+9Do you have a clean way to add 1.1 conditionally through another field/IF logic? The syntax is pretty easy - something like:
[Other Savings Field 2.1]+[Other Savings Field 2.2]+[Other Savings Field 2.3] +
If( condition goes here, [Other Savings Field 1.1], 0)
So lets say you had a checkbox to 'Include 1.1' - then you would have it like:
[Other Savings Field 2.1]+[Other Savings Field 2.2]+[Other Savings Field 2.3] +
If( [Include 1.1], [Other Savings Field 1.1], 0)
In the above it will return 0 if you don't want to include it.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
