AnsweredAssumed Answered

Using a range in an If Statement

Question asked by rwvanleer on Feb 8, 2013
Latest reply on Feb 11, 2013 by eshoshin

Hello all.


I am stuck on a scripting issue I could use some assistance with. I have a couple of fields which require user input and a calculation is returned in a third field. This all works fine however, the next step is what is throwing me off. Based on the range which the calculated result falls in I want to have another field populated with data. For example, if the calculation total is less than 3500 I want the last field to show 3500. If the number falls between 3501 and 4000 I would like it to show as 3750. There are total of 14 ranges each in increments of 500 each resulting in a different end number.


Getting the script to fill in the amount for totals less than 3500 was simple, but I am having problems getting it to work beyound that. Any ideas would be appreciated.