I have to evaluate a single number in a single cell and return a value based
on that number. How do I build a formula to do the following?
If the number is < 500, I need to return "Non-Target"
If the number is = 500 but < 1500, I need to return "Low"
If the number is = 1500 but < 3500, I need to return "Medium"
If the number is = 3500, I need to return a value of "High"

How do I build this formula