2 part question. I’m Looking for some advice on formulas. I understand the concept of displaying a 1or 0 as a true/false result, Im curious if there is a way to display the result of a formula in a separate text box. For example, If I were looking to have the formula [Box 1] *.3 display the result in a new text box, is that possible?
Also, the closing parentheses in the If statement seems to be “breaking” the formula. I’d love some advice on how to properly format those. for Example, if([Box1] + [Box2] = 100, 1, 0) ← the final parentheses seems to break the formula.
Thanks!