write a formula for excel

Question

hossein 2014-9-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/153451-write-a-formula-for-excel

回答： Geoff Hayes 2014-9-4

hi I want to write a long formula in excel like this: if(A1=$C1,1,if(A1=0,0,-.33))+if(A2=$C2,1,if(A2=0,0,-.33))+ ... for 1 to 100 to avoid copy and paste 100times I write a code in matlab but it error I wrote:

for i=1:100 display('if(Ai=$Ci,1,if(Ai=0,0,-.33))+') end how to change my code to write formula correctly?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Geoff Hayes 2014-9-4

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/153451-write-a-formula-for-excel#answer_150716

在 MATLAB Online 中打开

Hossein - just use fprintf

 for k=1:100 
    fprintf('if(A%d=$C%d,1,if(A%d=0,0,-.33))+',k,k,k); 
 end

The above will write a single line to the Command Window with all the if statements. If you want each statement on a separate line, just add \n to the end of the string

fprintf('if(A%d=$C%d,1,if(A%d=0,0,-.33))+\n',k,k,k);