用Excel设计带息分期付款万能查询系统

Using Excel to Design Versatile Inquiry System of Installment with Interest

将Excel的控件工具、数据链接技术和公式设计巧妙地进行结合运用,不需编程即可快速实现带息分期付款万能查询。随着鼠标的轻轻点击,分期销售货物品种、首付金额、利率和支付期限发生着如意变化,每期支付金额便也同步显示出来,实现了科学管理,提高了工作效率。

By ombining the control tool, data link technology and formula cleverly, we can realize the omnipotence payment consulting. Clicking the mouse, the amount of payment is shown synchronously when the sort of goods, the first payment, rate of interest and the time of payment change, which realize scientific management and improve the efficiency.