Multiple IF Function
I have 10 possible ranges to create a cell value. I cannot use "IF" beyond 7
and I keep seeing suggestions to use "Lookup", but it's not working. I need
some examples if they're out there. Here's what I'm trying to do:
If the cell value in "X" is: <30, then value is 1
30-34 then value is 2
35-39 then value is 3
and so on..........
|