Skip to main content
andyhfx
andyhfx
Participant
December 21, 2016
Answered

javascript equation help please...

  • December 21, 2016
  • 1 reply
  • 491 views

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 has been closed for replies.
Correct answer try67

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;

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
December 21, 2016

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;
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices