Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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+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")) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help on Logic test!!!
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 , "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")) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help on Logic test!!!
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")) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help on Logic test!!!
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 , JE McGimpsey 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")) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help on Logic test!!!
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+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")) |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help on Logic test!!!
I've replied to your posting in the functions group.
Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
logic test | Excel Discussion (Misc queries) | |||
logic test | New Users to Excel | |||
logic test | Excel Worksheet Functions | |||
hpw do I logic test a cell then copy the row to diff. SS | Excel Worksheet Functions | |||
Can wildcards be used in the Logic Test of an Excel "IF" function? | Excel Worksheet Functions |