How to Multiply value in adjacent cell by cell above, Autofil formula in Matlab?
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposta accettata
Matt Kindig
il 5 Ago 2013
Modificato: Matt Kindig
il 5 Ago 2013
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.
0 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Large Files and Big Data in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!