javascript equation help please...

[andyhfx]

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...

[try67 · Accepted solution]

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;