javascript equation help please...

1 reply
494 views
Translate

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

This topic is closed to new replies. Start a new post to keep the conversation going.

try67Correct answer

Community Expert

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;

try67

Correct answer

Community Expert

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;

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.