This doesn't make any more sense in this cross-post than it does in the other.
Re-state the whole thing and re-post BUT ONLY IN 1 DISCUSSION GROUP so that
multiple volunteers aren't all working on YOUR problem and not helping others.

--
Gary Brown

"jbf frylock" wrote:

Need some help. This is the formula I have now. It figures a salary range
and a categorilcally eligible logic test. If a household with x number of
people (A10) makes n they are free or reduced or paid. The differnce for
each increment is 4200 for the free category and 6000 for the reduced and
paid category.

=IF(L3<=(A10*4200+8203),"Free",IF(L3<=(A10*6000+11 674),"Reduced","Paid"))

What do you do if the difference isn't the same. What if x = 1 and on the
next cell n = 2 and the jump from income is 1000 to 2004 and then for a
houselhold of 3, the income is 3007. Then the rest of the household numbers
have a difference of 1004. How do I work the difference of 1003 into an
equation where all of the other amounts are 1004? I was told to use: A10 =
number of people. L4 = income for the people, 353 is the difference and 503
is the difference. What if the diffference was 354 for all but one (353) and
503 for all but one (504)? this is the equation I've been playing with.

=IF(L4<=684+(353*A10)+A10,"Free",IF(L4<=973+(503*A 10)+A10,"Reduced","Paid"))