Need help on Logic test!!!

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+11674),"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*A10)+A10,"Reduced","Paid"))

I may be being dense, but I have a hard time following your question. In
the unlikely case that I've understood it correctly, you could use
something like:

=IF(L4<=684+354*A10-(A10>=1), "Free", IF(L4<=973+504*A10-(A10>=1),
"Reduced", "Paid"))





In article <[email protected]>,
"jbf frylock" <[email protected]> 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+11674),"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*A10)+A10,"Reduced","Paid"))

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+11674),"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*A10)+A10,"Reduced","Paid"))
>

And, of course, if you don't care about the case where A10=0, this
reduces to

=IF(L4<=683+354*A10, "Free", IF(L4<=972+504*A10, "Reduced", "Paid"))

In article <[email protected]>,
JE McGimpsey <[email protected]> wrote:

> I may be being dense, but I have a hard time following your question. In
> the unlikely case that I've understood it correctly, you could use
> something like:
>
> =IF(L4<=684+354*A10-(A10>=1), "Free", IF(L4<=973+504*A10-(A10>=1),
> "Reduced", "Paid"))

Actually Gary, it was posted twice before you answered. I noticed the
subject was missing, so I posted it with a heading (again before you
answered). Sorry for the inconvenience and misunderstanding. Thanks for the
two kind and extremely helpful messages...have a blessed day. It is a
complicated spreadsheet to explain but somebody answered it and it made
sense, thanks for the time JE McGimpsey...I'll give it a try.

"Gary L Brown" wrote:

> 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+11674),"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*A10)+A10,"Reduced","Paid"))
> >

I've replied to your posting in the functions group.

Pete