I'm working on a PDF form (using Acrobat Pro 8) and I need a cell to calculate and display the following:
(((Cell X * 3 / 23) - Cell X) * -1)
Cell X refers to a single text box containing a numerical value.
Please note that I've added the spaces just for clarity in this message - the equation in my spreadsheet version of this document does not include spaces.
Assuming you have 2 text fields, called Textbox1 and Textbox2, have this as the custom calculation script for Textbox2:
var y = getField("Textbox1").value;
getField("Textbox2").value = (((y * 3 / 23) - y) * -1);
else getField("Textbox2").value = "";
Enter a number in Textbox1 and press Enter.
Many thanks Michael for your quick and accurate reply!