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!