Convert Excel Formula to Javascript

New Here ,
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!

Most Valuable Participant
Correct answer by try67 | Most Valuable Participant

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.

TOPICS
Acrobat SDK and JavaScript

Views

333

Likes

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

Convert Excel Formula to Javascript

New Here ,
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!

Most Valuable Participant
Correct answer by try67 | Most Valuable Participant

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.

TOPICS
Acrobat SDK and JavaScript

Views

334

Likes

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
Nov 15, 2018 0
Most Valuable Participant ,
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

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Dec 08, 2018 0