On 2002-04-17 21:24, dpolson wrote:
Try this:
=IF(G6<=2200,L10,IF(G6<2500,L11,IF(G6<3000,L12,"")))
You can embed up to 7 if statements. If you need more than that, there are ways around it by using more than one cell, each with your "maximum IF" equation, then a consolidation cell that sums the other cells containing your "maximum IF" equations. There are likely more efficient ways to do this, but since I don't know any better, I've found this works for me.
Dale