Hope you are still around Pete.

What if the difference isn't the same? what if it jumps from 1037 for a
household of 1 to 1390 for household of 2, then 1744 for a household of 3.
The difference goes from 353 to354, but down the list there may be a
difference of 356?

"Pete" wrote:

Just for the benefit of others, then...

Though your numbers in the second table look a bit messier, they follow
a similar relationship - the difference between each value in your
first threshold is 4,238 (was 4,000) with a constant value of 8,203
(was 6,000). Presumably, there has been some kind of cost-of-living
adjustment. For your second threshold the difference is 6,031 (was
5,000) with a constant of 11,674 (was 10,000), so you can substitute
these new values for the old at the appropriate places. The formula
will cater for any size of household.

If the numbers are likely to change in the future, you might like to
record them in the sheet and refer to the cells in the formula. For
example, if you do a little table in cells C1 to E2 as follows:

Constant 8203 11674
Increment 4238 6031

then you can change the formula in A3 to:

=IF(A2<=(A1*D2 + D1),"FREE",IF(A2<=(A1*E2 + E1),
"REDUCED","PAID"))

In future you only need to change the values in the table to keep up to
date.

Pete