I have a column listing a number in a range of 1 through 70. I need to
create a new column that assigns a dollar value to the row based on the
number in the first column. The bands I have created are as follows:
Numbers 30 and greater= $42,000
Numbers between 21 and 30 = $26,000
Numbers 20 and less = $10,000
I have tried IF statements without luck, any help would be appreciated.