=PRODUCT(SUM(PRODUCT(C4,0.0135),566),通俗易懂最好有数字举例最好

Question

=PRODUCT(SUM(PRODUCT(C4,0.0135),566),通俗易懂最好
有数字举例最好

Answer 1

1 PRODUCT函数是计算所有参数的乘积.如：PRODUCT(3,100)=3*100=100,
PRODUCT(3,100,)=3*100=100,
PRODUCT(3,100,0)=3*100*0=0,
PRODUCT(3,100,0.15)=3*100*0.15=45
2 SUM函数是求参数的和.如:SUM(100,50,0.7,-16)=100+50+0.7-16=134.7
3 以上函数化简：PRODUCT(SUM(C4*0.0135,566),)
= PRODUCT(C4*0.0135+566),)
= PRODUCT(C4*0.0135+566),1)
= (C4*0.0135+566)