Need help on Logic test!!!

G

Guest

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"))
 
J

JE McGimpsey

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"))
 
G

Guest

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.
 
J

JE McGimpsey

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"))
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top