How to create an If Then formula in a PDF

Forum|Forum|3 years ago
April 20, 2023
1 reply
1645 views

I need to know how to get a value to return as a Yes if a certain criteria is met and No if it is not met.

If the cell named "score" returns a value of 51 or higher, then I need the cell named "Text4" to return the value Yes. If "score" returns a value of 50 or lower, then "Text4" needs to return a value of No.

The cell "score" is setup to calculates a value based on other things in the form. So the value will change as more things are marked on the form.

Thank you in advance!

How to

This topic has been closed for replies.

Correct answer try67

As the custom calculation script of "Text4" enter the following:

event.value = Number(this.getField("score").valueAsString) <= 50 ? "No" : "Yes";

try67

Correct answer

Community Expert

As the custom calculation script of "Text4" enter the following:

event.value = Number(this.getField("score").valueAsString) <= 50 ? "No" : "Yes";

J

Jenny29512202vom0Author

Participant

Oh my gosh! You are the best. Thank you so much. You made my Friday.

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.

Scanning file for viruses.

This file cannot be downloaded