東企特定法院 違約金展開術

[JohnD59]

=IF(NOT(A2=""),IF(B2="有",IF(C2="有",IF(G2>DATE(2021,7,19),IF(D2<=16,"從"&TEXT(G2,"e/m/d")&"至清償日止，按"&D20.2&"%計算","從"&TEXT(G2,"e/m/d")&"至清償日止，按"&3.2&"%計算"),IF(D2<=16,"從"&TEXT(G2,"e/m/d")&"至清償日止，按"&D20.2&"%計算","從"&TEXT(G2,"e/m/d")&"至110/7/19止，按"&D20.2&"%計算，從110/7/20至清償日止，按3.2%計算")),IF(D2<=16,"從"&TEXT(EDATE(E2,1)+1,"e/m/d")&"至"&TEXT(EDATE(E2,7),"e/m/d")&"止，按"&D20.1&"%計算，從"&TEXT(EDATE(E2,7)+1,"e/m/d")&"至清償日止，按"&D20.2&"%計算","從"&TEXT(EDATE(E2,1)+1,"e/m/d")&"至"&TEXT(EDATE(E2,7),"e/m/d")&"止，按"&D20.1&"%計算，從"&TEXT(EDATE(E2,7)+1,"e/m/d")&"至110/7/19止，按"&D20.2&"%計算，從110/7/20至清償日止，按3.2%計算")),IF(C2="有",IF(F2>EDATE(E2,7),IF(D2<=16,"從"&TEXT(F2,"e/m/d")&"至清償日止，按"&D20.2&"%計算","從"&TEXT(F2,"e/m/d")&"至110/7/19止，按"&D20.2&"%計算，從110/7/20至清償日止，按3.2%計算"),IF(D2<=16,"從"&TEXT(F2,"e/m/d")&"至"&TEXT(EDATE(E2,7),"e/m/d")&"止，按"&D20.1&"%計算，從"&TEXT(EDATE(E2,7)+1,"e/m/d")&"至清償日止，按"&D20.2&"%計算","從"&TEXT(F2,"e/m/d")&"至"&TEXT(EDATE(E2,7),"e/m/d")&"止，按"&D20.1&"%計算，從"&TEXT(EDATE(E2,7)+1,"e/m/d")&"至110/7/19止，按"&D20.2&"%計算，從110/7/20至清償日止，按3.2%計算")),IF(D2<=16,"從"&TEXT(F2,"e/m/d")&"至"&TEXT(EDATE(F2,6)-1,"e/m/d")&"止，按"&D20.1&"%計算，從"&TEXT(EDATE(F2,6),"e/m/d")&"至清償日止，按"&D20.2&"%計算","從"&TEXT(F2,"e/m/d")&"至"&TEXT(EDATE(F2,6)-1,"e/m/d")&"止，按"&D20.1&"%計算，從"&TEXT(EDATE(F2,6),"e/m/d")&"至110/7/19止，按"&D2*0.2&"%計算，從110/7/20至清償日止，按3.2%計算"))))

[JohnD59]

A2=入帳金額 B2=有無沖本金 C2=有無沖違約金 D2=利率(未*0.1) E2=原始利息起算日 F2=最終違約金起算日 G2=沖帳後違約金起算日 無入帳尚未設定，以及除此之外正常法院皆未設定