Convert Excel Formula to Javascript

[ginaw2124944]

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!

[try67 · Accepted solution]

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.