Forum Discussion
Solved
Problem with nested IF formula #Excel #2018
Greetings, I am trying to create a formula that will check the value in the adjacent cell to determine if it falls within a specified range, and if so, return text for the range, i.e, 5-9. This is t...
Hi Laurie,
You may use
=LOOKUP(P12,{0,5,10,15,21},{"0-4","5-9","10-14","15-19","20+"})
Hi Sergei. This worked like a charm! Thanks so much!
You are welcome