Need Help with formula: One of 3 values based on a high and low threshold

Randy Van Winkle
Randy Van Winkle ✭✭✭
edited 12/09/19 in Formulas and Functions

Trying to set up a formula (IF?) where the value of a cell is either 0, 3 or 5 determined by the value of a result and if it is below a minimum threshold, in the middle or above a high threshold.  For the attached example, the first KPI result is 100% so it receives 5, second result is 4 falls in the middle so receives 3, third result is 50% is below minimum so it receives 0   

Capture 1 of 3 based on thresholds.PNG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!