Convert Excel Formula to Javascript

New Here ,
Nov 15, 2018 Nov 15, 2018

Copy link to clipboard

Copied

How would I convert this excel formula into JavaScript:

=IF(E3=0,0,F3/E3)

I'm needing this for an Adobe Form so the actually names are:

=IF(SCHEDULED1=0,0,COMPLETEDSTORED1/SCHEDULED1)

thanks!

TOPICS
Acrobat SDK and JavaScript

Views

351

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

Most Valuable Participant , Dec 08, 2018 Dec 08, 2018
I moved your question from the wasteland that is the Coding Corner forum to the much more lively and relevant Acrobat JavaScript forum, for starters...This is a good place to start:https://acrobatusers.com/tutorials/conditional-execution https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations Note that you'll need to make sure the denominator is not empty or zero, or you'll get error messages when trying to divide by it.

Likes

translate

Translate

Translate
Most Valuable Participant ,
Dec 08, 2018 Dec 08, 2018

Copy link to clipboard

Copied

I moved your question from the wasteland that is the Coding Corner forum to the much more lively and relevant Acrobat JavaScript forum, for starters...

This is a good place to start:

https://acrobatusers.com/tutorials/conditional-execution

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

Note that you'll need to make sure the denominator is not empty or zero, or you'll get error messages when trying to divide by it.

Likes

translate

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines