Maybe you should put in a table and then use a lookup table to the criteria of the price breaks you are after. Then infuse that query into your if, then nested function. It might help you out substantially. You would just need to correct the price break table when prices change. For instance IF(B2>50,Vlookup(table,column),""). I think a table would help your query greatly cut down the data inputs.