I have the following in an excel cell: =IF(N32>75,N32-75,0)
Can anyone help me with turning that into an equation I can use in Acrobat Pro X?
Thank you very much to any replies...
Assuming the field names in the PDF file are the same as those of the cells in the Excel file, you can use this code (as a custom calculation script) to achieve it:
var v1 = Number(this.getField("N32").value);
if (v1>75) event.value = v1-75;
else event.value = 0;
Retrieving data ...