How to create a dynamic/easily changeable threshold?

[johny9887]

Hi,

Currently in the attached workflow, I am creating a KPI1Rank and KPI2Rank columns by using a formula tool which assigns rank value based on a certain threshold:

As you can see, the thresholds 0, 3, 6 are currently hard coded as part of the formula

Is there a way to have it dynamically change (i.e have the users change the thresholds without having the change the values in the formula)

Thank you 

[Robin_McIntosh]

Here's an interface asking for the 3 thresholds which default to your 0/3/6.  These values (default or user changed) are then passed to the formula.