conditional statement in one line for table columns

logic: if(p2>0) r4=q2/p2 else r4=2*q2/p2 Question : how to convert this into r4={if p2>0?r4=q2/p2:r4=2*q2/p2} in matlab? p2 and q2 are columns of table.

Answer 1

[alice]

Have a look at the documentation, for example these: find-array-elements-that-meet-a-condition and element-wise-multiplication.

In your case, you can do:

r4 = (p2>0).*(q2./p2) + (p2<=0).*(q2./p2)*2;

Answer 2

[Guillaume]

Or, rather than relying on semi-obscure mathematical expressions:

r4 = q2 ./ p2;
r4(p2 > 0) = 2 * r4(p2 > 0);

In my opinion, a lot clearer as to the intent.