Number in between 2 values
I have a range of numbers that correspond with a tier level. I have figured out Tier I and III, but I'm not sure how to account for Tier II being between 2 values: >21000, <40000.
=IF([AVG. STORE UNITS]@row <= 21000, "TIER III", IF([AVG. STORE UNITS]@row >= 40000, "TIER I"))
I appreciate any and all help!
Help Article Resources
Check out the Formula Handbook template!