NBVC,
Thanks for all of the help. When I enter the formula you created in my spreadsheet I get [0]. That's exactly what I'm trying to do. Each IF/THEN formula is connected to a number [1-10].
Thanks again.