Thanks Pete, this is so much simpler than what I was trying to do. You are a
life saver. One more question if you don't mind.

Why 4000+6000 or 5000+10000. I have different numbers that will need to be
used in the chart.

Free Reduced
household size annual inc. annual inc.
1 $12441 $17,705
2 $16,679 $23,736
3 $20,917 $29,767
4 $25,155 $35,798
5 $29,393 $41,829
6 $33,631 $47,860
7 $37,869 $53,891
8 $42,107 $59,922

I also need to add $4,238 for each additional member in the FREE category
and $6,031 for each additional in the REDUCED. So if there were 15 in the
free it would add 4238 to income for each additional member.


"Pete" wrote:

Okay, there is a simple relationship between the threshold levels in
your example, so all you will need is the following formula in cell A3:

=IF(A2<=(A1*4000+6000),"Free",IF(A2<=(A1*5000+1000 0),
"Reduced","Paid"))

assuming that A1 contains the number of people and A2 is the income.

Try that out with some example values.

Pete