Multiple IF Function
Another way:
=LOOKUP(A1,{0,1,30,35},{"",1,2,3})
Biff
"Roberto" wrote in message
...
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..........
|