formulas in excel
 

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

If 7 or less try this idea starting with the higher numbers first, as shown
here. If more, look in HELP index for VLOOKUP

=IF(C3120,1,IF(C3100,2,IF(C380,3)))

--
Don Guillett
SalesAid Software

"gaynie" wrote in message
...
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

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