If Statement Multiple Conditions

[ahigley]

Using LiveCycle, FormCalc or JavaScript.

I am trying to create an if statement with multiple conditions.

a Sum field calculates a series of numeric input fields. I want the result in the Sum field to determine the expression in a final field. 

If the Sum is <30MM then "50000" also if the Sum is >30MM but <60MM then "125000" also if the Sum is >60MM but <100MM then "250000" also if the Sum is >100MM but <300MM then "375000" also if the Sum is >300MM then "500000"

I have only been able to figure out a single if then for the first condition but not able to include the whole set of conditions and the multiple results.

Help would be much Appreciated!

Thank you in advance.

[Former Community Member]

I woudl use a Javascript

switch staement.

switch (expression)

{

     case label1:

          statement1;

          statement2;

          break;

     case label2:

          statement1;

          statement2;

          break;

}

You can cover as many cases as you want. If you do a web serach for Javascript Switch statement there are numerous examples out there that you can follow.

Paul

[ahigley]

Tried a few variations of this and still seem not

to be able to find a solution to this issue. I'm surprised my google searches are bringing up better examples because there seems to be an example of everything else.

Any more detailed advive?

[Former Community Member · Accepted solution]

Send your form to LiveCycle8@gmail.com and I will ahve a look and see what is wrong.

Paul

[ahigley]

Paul, Thanks so much! Perfect!!

[mthys]

It helps everyone else when correct answers are also posted...