View Single Post
  #1   Report Post  
tjtjjtjt
 
Posts: n/a
Default

Have a look at VLOOKUP:
http://www.contextures.com/xlFunctions02.html

tj

"gaynie" wrote:

Hi
I have a column of numbers between 0 and 150. If the value is between 2
amounts say 0 and 22 then i want it to return with a value that i set. If its
between 23 and 28 then return a different value. And so on up to 150. Is it
possible to do this?

Thanks