If statement with negative numbers = stumped analyst

I think the easiest thing to do is to use the VLOOKUP function. Create a table of your criteria going from lowest to highest. Then highlight the table and name it (I called it quota in my example) (Name it by highlighting and then entering the table name in the name box).
VLOOKUP uses the following format[quote]=VLOOKUP(value to lookup or cell where value is, table range or name, column to return 2 in your case)[/code]

Look at my example and check Excel help and let us know if you have any questions.

ChemistB