Hi,
I suggest you can use Labtalk script to set the columns value.
When the worksheet is active, select "Window: Script Window".
Then in the Script Window enter the following script, highlight them and click "Enter" key.
range aa=col(a); //Access column a on the active worksheet
range bb=col(b);
range cc=col(c);
range dd=col(d);
for( int ii = 1 ; ii <= aa.GetSize() ; ii++ ) //loop all rows
{
if( aa[ii] < bb[ii] )
cc[ii] = aa[ii]/bb[ii];
else
dd[ii] = aa[ii]/bb[ii];
};
If you want to know more detail about loop and If Labtalk script, please refer to these online help pages:
http://www.originlab.com/doc/LabTalk/ref/For-cmd
http://www.originlab.com/doc/LabTalk/guide/Flow-of-Control
http://www.originlab.com/doc/LabTalk/ref/If-cmd
Thanks
OriginLab
Jacqueline