I need assistance figuring out a formula for a form.
Tier I field FieldA
Tier II field FieldB
Athe the top of my form, I have two fields AMT1 and AMT2. I need for FieldA to return the diference between AMT1 and AMT2 equal to or less than three. If the difference is greater than 3, FieldA would equal 3 and the difference would be in FieldB.
Example1: AMT1 = 6 AMT2 = 15 Difference is 9
FieldA should be 3 and FieldB should be 6
Example2: AMT1 = 6 AMT2 = 8 Difference is 2
FieldA should be 2 and FieldB should be 0 or blank>
I'm new to creating complex forms and really could use any help I can get.
If anyone knows of an Adobe product thathas more complex formula example, I'd love to know about it.
Scott
