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+"})
or use Sergei's answer which is even better..
It is very efficient. I appreciate both answers!