write a formula for excel

hossein

2014 9 4

1 个回答

回答已采纳

1 次查看（30 天）

0 个投票

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更早的评论

请先登录，再进行评论。

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

Follow Question

采纳的回答

Geoff Hayes 2014-9-4

在 MATLAB Online 中打开

1 个投票

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);