formula with multiple parameters
Hello,
I have a check box that I need to automatically be checked if the value of the request is >2500 and <15000. I had this worked out fine with the formula:
Case([Total]>2500,([Total]<500...
Forum Discussion
Something like this should work, you'll just need to add the rest of your folks...
var number requestMin = 2500;
var number requestMax = Case([DOC],
"Sean Regan", 5000,
"Grafton Montgomery", 5000,
"Jeron Pearson", 15000
);
[Total] > $requestMin and [Total] < $requestMax
------------------------------
Chris Wheatley
------------------------------