Javascript for PDF form calculation

Question

Hi, I'm new to PDF forms and need to insert a calculation into a form. I've mastered the basic calculations, but need a custom calculation for this one. Can any one help me with it? Here's the formula from excel:

=50+((10*SUM(A1:A10))/(SQRT(0.7*SUMSQ(B1:B10)+0.3*(POWER(SUM(B1:B10),2)))))

Any help greatly appreciated.

John

try67 · Answer

There's no one-to-one conversion from Excel to Acrobat JS.

Some functions (like SQRT) do have a direct JS equivalent (Math.sqrt), others (like SUM) don't and you'll need to write your own code to achieve the same result.

See:

JavaScript Math Reference

https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations

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.

Scanning file for viruses.

This file cannot be downloaded