谷歌电子表格中的动态减法 [英] Dynamic subtraction in Google Spreadsheet
本文介绍了谷歌电子表格中的动态减法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
请查看我的电子表格:
Please have a look at my spreadsheet: https://docs.google.com/spreadsheets/d/1K5Btg5fFS590G7vZsFiepY-2VTPhzJIlkKK_o-9Ag7E/edit?usp=sharing
How do I get:
- C2 to show
Start weight
(i.e. "100,0") - C3 to show C2 -
Daily weightloss
(i.e. "99,7701") - C4 to show C3 -
Daily weightloss
(i.e. "99,5402) - C5 to show C4 -
Daily weightloss
(i.e. "99,3103") - ...and so on.
The challenge is obviously to do this dynamically since all the user-submitted data, and consequently, all the calculated data might change.
I think this can/should be solved with ArrayFormula somehow but I don't know how.
解决方案
=ARRAYFORMULA(IF(A2:A;
MMULT(TRANSPOSE((ROW(INDIRECT("B2:B"&COUNTA(A1:A)))<=
TRANSPOSE( ROW(INDIRECT("B2:B"&COUNTA(A1:A)))))*
{B2; TRANSPOSE(SPLIT(REPT(J5*-1&"♦"; COUNTA(A3:A)); "♦"))});
SIGN({B2; TRANSPOSE(SPLIT(REPT(J5*-1&"♦"; COUNTA(A3:A)); "♦"))})^2); IFERROR(1/0)))
这篇关于谷歌电子表格中的动态减法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文