谁能帮我解释下列一条EXCEL的VBA公式,是怎么运算的,还原成表格的公式=TRUNC(301*(COUNTA(C[-3])-ROW(R[-1]C[-3]))/COUNTA(C[-3]),0)
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/03 14:52:53
![谁能帮我解释下列一条EXCEL的VBA公式,是怎么运算的,还原成表格的公式=TRUNC(301*(COUNTA(C[-3])-ROW(R[-1]C[-3]))/COUNTA(C[-3]),0)](/uploads/image/z/2693538-18-8.jpg?t=%E8%B0%81%E8%83%BD%E5%B8%AE%E6%88%91%E8%A7%A3%E9%87%8A%E4%B8%8B%E5%88%97%E4%B8%80%E6%9D%A1EXCEL%E7%9A%84VBA%E5%85%AC%E5%BC%8F%2C%E6%98%AF%E6%80%8E%E4%B9%88%E8%BF%90%E7%AE%97%E7%9A%84%2C%E8%BF%98%E5%8E%9F%E6%88%90%E8%A1%A8%E6%A0%BC%E7%9A%84%E5%85%AC%E5%BC%8F%3DTRUNC%28301%2A%28COUNTA%28C%5B-3%5D%29-ROW%28R%5B-1%5DC%5B-3%5D%29%29%2FCOUNTA%28C%5B-3%5D%29%2C0%29)
xTnA}/
pc(
3mBZ5iz`Vd`_ec6&,/33;\f]V1f3n"d}cHvy(GPhOxxb=},1k_S'*rYǤuh߄]lш0ܖPt/l=dvCҞxHH0u_Rs_8LY-l|Xxnٍ@hQfu^OЂܚy"~>Sh 8/A&,ȏ %2?,qlj #Yc+u