贷款与分期付款表格

GeoGebra 命令及参数

1. If((C7 * $C$4) > $B$4, Min[$B$4, (C7 * $C$4)], Max[(C7 * $C$4), 0]) → B8
2. If((C7 * $C$4) < $B$4, 0, (C7 * $C$4) - B8) → C8
3. If((C8 * $C$4) > $B$4, Min[$B$4, (C8 * $C$4)], Max[(C8 * $C$4), 0]) → B9
4. If((C8 * $C$4) < $B$4, 0, (C8 * $C$4) - B9) → C9
5. If((C9 * $C$4) > $B$4, Min[$B$4, (C9 * $C$4)], Max[(C9 * $C$4), 0]) → B10
6. If((C9 * $C$4) < $B$4, 0, (C9 * $C$4) - B10) → C10
7. If((C10 * $C$4) > $B$4, Min[$B$4, (C10 * $C$4)], Max[(C10 * $C$4), 0]) → B11
8. If((C10 * $C$4) < $B$4, 0, (C10 * $C$4) - B11) → C11
9. If((C11 * $C$4) > $B$4, Min[$B$4, (C11 * $C$4)], Max[(C11 * $C$4), 0]) → B12
10. If((C11 * $C$4) < $B$4, 0, (C11 * $C$4) - B12) → C12
11. If((C12 * $C$4) > $B$4, Min[$B$4, (C12 * $C$4)], Max[(C12 * $C$4), 0]) → B13
12. If((C12 * $C$4) < $B$4, 0, (C12 * $C$4) - B13) → C13
13. If((C13 * $C$4) > $B$4, Min[$B$4, (C13 * $C$4)], Max[(C13 * $C$4), 0]) → B14
14. If((C13 * $C$4) < $B$4, 0, (C13 * $C$4) - B14) → C14
15. If((C14 * $C$4) > $B$4, Min[$B$4, (C14 * $C$4)], Max[(C14 * $C$4), 0]) → B15
16. If((C14 * $C$4) < $B$4, 0, (C14 * $C$4) - B15) → C15
17. If((C15 * $C$4) > $B$4, Min[$B$4, (C15 * $C$4)], Max[(C15 * $C$4), 0]) → B16
18. Textfield(Loan) → Loan_amount
19. Textfield(m) → InputBox1
20. Textfield(instalment) → InputBox2
21. If((C15 * $C$4) < $B$4, 0, (C15 * $C$4) - B16) → C16
22. If((C16 * $C$4) > $B$4, Min[$B$4, (C16 * $C$4)], Max[(C16 * $C$4), 0]) → B17
23. If((C16 * $C$4) < $B$4, 0, (C16 * $C$4) - B17) → C17
24. TableText({{A6, B6, C6}, {A7, B7, C7}, {A8, B8, C8}, {A9, B9, C9}, {A10, B10, C10}, {A11, B11, C11}, {A12, B12, C12}, {A13, B13, C13}, {A14, B14, C14}, {A15, B15, C15}, {A16, B16, C16}, {A17, B17, C17}}, "|_lll") → text4