=LOOKUP(A1,{0,21,30},{10000,26000,42000})

Enter in B1 and double-click on the B1 fill handle to autofill.


Gord Dibben Excel MVP

On Wed, 18 May 2005 16:01:02 -0700, slh wrote:

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.