Excel Formula to Java in PDF Forms

3 replies
385 views
Translate

Hi All,

This is regarding an IF statement in excel to "translate it" in JavaScript for PDF forms.

I know this kind of question has been addressed so many times, however, all of the questions are with only 1 cell, whereas my case is a bit more complex.

This is the excel function as is:

=IF(B12="Ball",IF(C26=1,20,IF(C26=2,30,(C26-2)*5+40)),IF(B12="Rocket",IF(C26=1,10,IF(OR(C26=2,C26=3),15,20))))

As you can see there are multiple dependent cells and I can't seem to make it work in Java.

Note: every cell name is a corresponding field in PDF form.

Your support will be highly appreciated.

Thank you,

Mihai

Acrobat SDK and JavaScript

This topic is closed to new replies. Start a new post to keep the conversation going.

try67

Community Expert

See these tutorials:

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

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

Translate

T

Test Screen Name

Legend

Not Java, JavaScript. This may seem picky, but if you go searching the web for info on Java and Acrobat you will get nothing useful at all. You will need to use getField for each named cell (field). And IF needs to be written as a series of tests, rather than the one IF(cond,yes,no) form.

Translate

M

Mihai25722102rehfAuthor

Participant

Corect, is Java Script, please excuse my typo. I believe it is clear that I have little knowledge on how to script this. I do know the same conditional in excell doesn't work in JavaScript and you have to break it down, I just don't know how as I have no knowledge of JavaScript. My work domain is totally different.

I managed to get the code for only 1 condition, but what I need is a bit more complex, as the result depends on a selection of 2 choices.

Can you help me?

Translate

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.