How to Multiply value in adjacent cell by cell above, Autofil formula in Matlab?

Question

Michelle H 2013-8-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84020-how-to-multiply-value-in-adjacent-cell-by-cell-above-autofil-formula-in-matlab

Hello, there must be an easy way to do this!

i have an excel file, that has been imported to matlab,

what i would like to do is perform a calculation the same way i would do in excel (and autofill down). what i would like is to multiply the answer in the cell above by the adjacent cell to get a final answer ... and do this for all rows

For instance my excel file below

StartVar = 5

A B C ANS

1 2 -1 (Startvar * -1)

2 2 +2 (above var * 2)

3 3 -2 (above var * -2)

4 3 -4 (above var * -4)

etc

for instance the ANS column will now be

-5

-10

+20

-80

..

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Matt Kindig 2013-8-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/84020-how-to-multiply-value-in-adjacent-cell-by-cell-above-autofil-formula-in-matlab#answer_93589

编辑：Matt Kindig 2013-8-5

在 MATLAB Online 中打开

There is no generic "autofill" command. For the example you've given, the following logic would work:

StartVar = 5;
multipliers = [-1 2 -2 -4];
ANS = StartVar*cumprod(multipliers)';

There are of course other ways to do the same thing. Incidentally, since the multipliers are not changing by a regular increment, I'm not sure how you would use the autofill in Excel to do this either.