I have a reference chart that has many columns with many rows of information i have created a formula to read the chart and output an answer based on what it reads, but after further review I need the output to have one more stipulation.
=IF(COUNTIFS('ESU1'!A3:A50,"*DIRECT*",'ESU1'!B3:B50,"*CONSOLIDATION*",'ESU1'!C3:C50,">="&DATE(2011,10,1)),"On or After 10/01/2011",IF(COUNTIFS('ESU1'!A3:A50,"*DIRECT*",'ESU1'!B3:B50,"*CONSOLIDATION*",'ESU1'!C3:C50,"<"&DATE(2011,10,1)),"Before 10/01/2011","Needs to be Done"))
I want the fourth stipulation to check also if there are any other rows minus their row with a balance....
COUNTIFS('ESU1'!A3:A50,"*DIRECT*",'ESU1'!B3:B50,"*CONSOLIDATION*",'ESU1'!C3:C50,">="&DATE(2011,10,1)),"On or After 10/01/2011" so this is true (Bold lines), but i want different output because the other rows (highlighted in red) have balances in them
I want to verify the above stipulations and include if all these are true, but there are balances in the other cells of that column, other than the bolded balances, then = false
REFERENCE CHART
<colgroup><col><col><col span="9"></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
=IF(COUNTIFS('ESU1'!A3:A50,"*DIRECT*",'ESU1'!B3:B50,"*CONSOLIDATION*",'ESU1'!C3:C50,">="&DATE(2011,10,1)),"On or After 10/01/2011",IF(COUNTIFS('ESU1'!A3:A50,"*DIRECT*",'ESU1'!B3:B50,"*CONSOLIDATION*",'ESU1'!C3:C50,"<"&DATE(2011,10,1)),"Before 10/01/2011","Needs to be Done"))
I want the fourth stipulation to check also if there are any other rows minus their row with a balance....
COUNTIFS('ESU1'!A3:A50,"*DIRECT*",'ESU1'!B3:B50,"*CONSOLIDATION*",'ESU1'!C3:C50,">="&DATE(2011,10,1)),"On or After 10/01/2011" so this is true (Bold lines), but i want different output because the other rows (highlighted in red) have balances in them
I want to verify the above stipulations and include if all these are true, but there are balances in the other cells of that column, other than the bolded balances, then = false
REFERENCE CHART
UNSUBSIDIZED | SCHOOL | 7/13/2018 | 2/21/2019 | $1,179 | $590 | $589 | $608 | $3 | FIXED | 5.05% |
SUBSIDIZED | SCHOOL | 7/13/2018 | 2/21/2019 | $2,750 | $1,375 | $1,375 | $1,375 | $7 | FIXED | 5.05% |
DIRECT STAFFORD UNSUBSIDIZED | SCHOOL | 5/4/2018 | 2/21/2019 | $1,710 | $1,710 | $0 | $1,771 | $8 | FIXED | 4.45% |
SUBSIDIZED | SCHOOL | 5/4/2018 | 2/21/2019 | $2,750 | $2,750 | $0 | $2,750 | $13 | FIXED | 4.45% |
UNSUBSIDIZED | SCHOOL | 8/11/2017 | 2/21/2019 | $933 | $933 | $0 | $946 | $4 | FIXED | 4.45% |
SUBSIDIZED | SCHOOL | 8/11/2017 | 2/21/2019 | $1,375 | $1,375 | $0 | $1,375 | $6 | FIXED | 4.45% |
DIRECT CONSOLIDATED UNSUBSIDIZED | SCHOOL CODE FOR CONSOLIDATION LOANS | 5/31/2017 | 5/31/2017 | $34,108 | $34,108 | $0 | $34,361 | $2,379 | FIXED | 4.75% |
DIRECT CONSOLIDATED SUBSIDIZED | SCHOOL CODE FOR CONSOLIDATION LOANS | 5/31/2017 | 5/31/2017 | $13,592 | $13,592 | $0 | $13,595 | $490 | FIXED | 4.75% |
UNSUBSIDIZED | SCHOOL | 9/22/2016 | 5/31/2017 | $2,333 | $2,333 | $0 | $0 | $0 | FIXED | 3.76% |
<colgroup><col><col><col span="9"></colgroup><tbody>
</tbody>
Loans Before 2014 | Consolidated | Grad/Parent Plus | |||
Yes | Needs to be Done | No | |||
Principle Balance | Interest Balance | Interest Rate | Weight | Sub or Unsub | |
Loan 1 | $608.00 | $3.00 | 5.05% | 3086% | Unsub |
Loan 2 | $1,375.00 | $7.00 | 5.05% | 6979% | Sub |
Loan 3 | $1,771.00 | $8.00 | 4.45% | 7917% | Unsub |
Loan 4 | $2,750.00 | $13.00 | 4.45% | ##### | Sub |
Loan 5 | $946.00 | $4.00 | 4.45% | 4228% | Unsub |
Loan 6 | $1,375.00 | $6.00 | 4.45% | 6145% | Sub |
Loan 7 | $34,361.00 | $2,379.00 | 4.75% | ##### | Unsub |
Loan 8 | $13,595.00 | $490.00 | 4.75% | ##### | Sub |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>