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

javascript equation help please...

  • December 21, 2016
  • 1 respuesta
  • 492 visualizaciones

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

Este tema ha sido cerrado para respuestas.
Mejor respuesta de 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 respuesta

try67
Community Expert
try67Community ExpertRespuesta
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;
Términos y condicionesAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices