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