Need Help with formula: One of 3 values based on a high and low threshold
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
Help Article Resources
Check out the Formula Handbook template!