I am trying to find a way that can automate using a number of ranges. For example
Ex.
If cell A1 is 25-45 A2 is 6
if cell A1 is 45-65 or 15-25 A2 is a 7
If cell A1 is 100-150 or 4-8 A2 is 10
How would a create an IF formula to do this? Or is there another formula that would be better?
Ex.
If cell A1 is 25-45 A2 is 6
if cell A1 is 45-65 or 15-25 A2 is a 7
If cell A1 is 100-150 or 4-8 A2 is 10
How would a create an IF formula to do this? Or is there another formula that would be better?