Question

excel内的公式怎么简化？

=(F5-(N5-F5*12.68%/12))-(N5-(F5-(N5-F5*12.68%/12))*12.68%/12)-(N5-((F5-(N5-F5*12.68%/12))-(N5-(F5-(N5-F5*12.68%/12))*12.68%/12))*12.68%/12)

Answer 1

1. 简化后公式：

   =(1+3*12.68%/12+3*(12.68%/12)^2+(12.68%/12)^3)*F5-(3+3*12.68%/12+(12.68%/12)^2)*N5

2. 如图所示：

   
   

Answer 2

不知是什么目的，EXCEL中有许多这方面的财务函数，可以按目的选用。

Answer 3

用自定义函数可简化，将N5和H5作参数调用即可