Anyone working with Microcal Origin?

[IndiJones]

microcal origin set column value

I have three columns of data A(1..10), B(1..10) & C(1..10) and a (3 X 3) matrix in column D(1..3), E(1..3) & F(1..3). I want to set the following values for each cell of columns G, H & I:

Value of G1 is
{if D1*A1+E1*B1+F1*C1 is less than 0, it will give 0, else the calculated value}

Value of H1 is
{if D2*A1+E2*B1+F*C1 is less than 0, it will give 0, else the calculated value}

Value of I1 is
{if D3*A1+E3*B1+F3*C1 is less than 0, it will give 0, else the calculated value}

Value of G2 is
{if D1*A2+E1*B2+F1*C2 is less than 0, it will give 0, else the calculated value}

Value of H2 is
{if D2*A2+E2*B2+F2*C2 is less than 0, it will give 0, else the calculated value}

......and so on.

In Excel, this could easily be done for cell G1 with the following equation:

=IF($D$1*A1+$E$1*B1+$F$1*C1<0,0,$D$1*A1+$E$1*B1+$F$1)

How can I do this in Origin?

 

[KamW]

In Origin triadic operation works:
(a<b?c:d) mean if (a<b) then c else d
You could use it in set column value or in script

hope it helps
regards
KamW