Hello everyone,
I am having trouble trying to figure out how to have 3 fields equal to 100%. To further explain, what I want to ultimately achieve is when you type a number into of one the fields (for eg. 37) I want the other 2 fields to automatically show the remaining 63 with (31.5 in each field). This is just an example as I want be able to input any sum that into one or more of the fields and the 3rd field will automatically do the math and equal to 100.
I am hopeless with Javascript, so I am hoping that somebody out there can show me how to do this whilst explaining the formula as well.
Thank you all.
Sash
Thank you all for your time in posting your responses but I need this is for Acrobat 9 not Excel.
I tried try67's and yes it worked in one way. The only problem is, when I place a number in field1 I can't change field2 or field3. I want to be able to change any one of the 3 fields and the number in the other fields to be able to change automatically.
So for example, I type in 70 in field1, 10 in field2 then field3 should automatically be 20, or let's say I go back and change field3 to 30, field2 to 50 and then field1 should automatically be 20. I want the fields to automatically do the math no matter which field I type in.
I hope this is clearer and if you need further clarification, please let me know.
Thanks
Sash
For the first scenario you can use this code in the Simple Field Notation field of field2 and field3 (assuming the names of the fields are field1, field2 and field3):
(100 - field1) / 2
For the second scenario, if field1 and field2 are filled in, place this as the Simple Field Notation calculation of field3:
100 - (field1 + field2)
If you use this method you may not have any spaces or periods in the names of your fields.
- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com