adjusting quantities

[mrhurtubise]

I have a bunch of values in column A between 0 and 500

- i want to break the values into ranges and :

if the value in column A is less than 10 put a 0 in the column B,
if the value in column A is between 11-30 put a 3 in the column B,
if the value in column A is between 31-50 put a 10 in the column B,
if the value in column A is between 51-100 put a 20 in the column B,
if the value in column A is above 100+ put a 40 in the column B,

i have attached an example of how i would like it to look.
i am guessing there is more than one way to accomplish this but i am not great with excel
could i uses a "IF" "AND" "OR" statement or a table of some sort

any help would be much appreciated.

[phbryan]

Try this outexcel forum help file.xlsx

[mrhurtubise]

sorry forgot to take out the +'s and none's

[mrhurtubise]

that does what i want

-thanks phbryan

[samba_ravi]

=IFERROR(LOOKUP(A1,{0,11,31,51,101},{0,3,10,20,40}),"")
try this

[mrhurtubise]

this works as well and is a little easier to use/change...knew there was going to be more than one way to do this.

thank nflsales