Multiplying spreadsheet column by variable

3 views (last 30 days)
Hello can a spreadsheet column be multiplied by a variable of a function to generate a new column?
g.

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 30 Jul 2016
Edited: Azzi Abdelmalek on 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 Comments
Gavin Seddon
Gavin Seddon on 1 Aug 2016
Thanks for this, I will use the xlsread/write because I use Mac. Do you have a URL for these operators?

Sign in to comment.

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by