Skip to main content
G
ginaw2124944
Participant
November 15, 2018
Answered

Convert Excel Formula to Javascript

  • November 15, 2018
  • 1 reply
  • 916 views

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!

This topic has been closed for replies.
Correct answer try67

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.

1 reply

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
December 8, 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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices