Write results in Excel under multiple If statements

2019 3 14
1 个回答
回答已采纳
更新时间：2019 3 14
6 次查看（30 天）

0 个投票

Hi there,
I would like to ask how can I use multiple if statements. I have written the following code but I only get results for the first if statements.
for j = 1 : 2
x = randn(10,1)
for k=1:2
y = randn(10,1)
if j == 1 & k == 1
xlswrite('Test.xls', [x y], 'Test1', 'b2');
if j == 1 & k == 2
xlswrite('Test.xls', [x y], 'Test1', 'p2');
if j == 2 & k == 1
xlswrite('Test.xls', [x y], 'Test1', 'b20');
if j == 2 & k == 2
xlswrite('Test.xls', [x y], 'Test1', 'p20');
end
end
end
end
end
end
I would appreciate any help. Thank you.

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

 采纳的回答

Alex Mcaulley
Alex Mcaulley 2019-3-14
编辑：Alex Mcaulley 2019-3-14

0 个投票

You need to close every if statement:
for j = 1 : 2
x = randn(10,1);
for k=1:2
y = randn(10,1);
if j == 1 && k == 1
xlswrite('Test.xls', [x y], 'Test1', 'b2');
end
if j == 1 && k == 2
xlswrite('Test.xls', [x y], 'Test1', 'p2');
end
if j == 2 && k == 1
xlswrite('Test.xls', [x y], 'Test1', 'b20');
end
if j == 2 && k == 2
xlswrite('Test.xls', [x y], 'Test1', 'p20');
end
end
end

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Hypothesis Tests 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by