If, Else Statement Help

[DJ_Avalon]

I am working on an Adobe Form where I need a field to poulate a value based on the value in another field.

Here is the scenario:

Total_Score1	Performance_Rating1
22-24	EE
16-21	ME
10-15	NI
0-9	DNM

I tried using this on my Adobe Form to populate field "Performance_Rating1"

if ("TOTAL_SCORE1" > 21){ event.value = "EE";

} else if ("TOTAL_SCORE1" > 15){ event.value = "ME";

} else if ("TOTAL_SCORE1" > 9){ event.value = "NI";

} else event.value = "DNM";

The only result I am getting is "DNM" regardless of the value in TOTAL_SCORE1

[jane-e]

I am working on an Adobe Form

By @DJ_Avalon

Adobe is a company that make a lot of applications. Possibly you mean Acrobat? Let us know which Adobe app you are using and we will move your post for you.

Jane

[DJ_Avalon]

Thank you for the reply!  Yes it is an Adobe Acrobat form

[kglad]

in the future, to find the best place to post your message, use the list here, https://community.adobe.com/

p.s. i don't think the adobe website, and forums in particular, are easy to navigate, so don't spend a lot of time searching that forum list. do your best and we'll move the post (like this one has already been moved) if it helps you get responses.

<"moved from using the community">

[DJ_Avalon · Accepted solution]

Thank you.  I found the help I needed in another discussion...  This is the formula that worked

if (getField("TOTAL_SCORE1").value > 21){ event.value = "EE"; }

else if (getField("TOTAL_SCORE1").value > 15){ event.value = "ME"; }

else if (getField("TOTAL_SCORE1").value > 9){ event.value = "NI"; }

else event.value = "DNM";

[kglad]

you're welcome, and thank you for posting the solution!