Multiplying spreadsheet column by variable
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Gavin Seddon
am 30 Jul. 2016
Kommentiert: Gavin Seddon
am 1 Aug. 2016
Hello can a spreadsheet column be multiplied by a variable of a function to generate a new column?
g.
1 Kommentar
Akzeptierte Antwort
Azzi Abdelmalek
am 30 Jul. 2016
Bearbeitet: Azzi Abdelmalek
am 30 Jul. 2016
A=randi(10,4,3) % Example
Cst=10
A=[1;2;3]
B=A(:,2)*Cst %Multiply column 2 by constant Cst
5 Kommentare
Azzi Abdelmalek
am 30 Jul. 2016
Bearbeitet: Azzi Abdelmalek
am 30 Jul. 2016
- You need to import your excell file using the Matlab function xlsread
- Use Matlab functions and operators to do the calculations you need, there are several Matlab functions, allowing you to do many kind of calculation and processing
- you can also link Excel to Matlab and use Matlab functions in Excel spreedsheet.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!