column values dependent on another column
Hi, I have two columns, and I hope the values of column 2 will depend on column 1 through a kind of Boolean control.For example, I need the column 2 below to be automatically filled:if Column 1>0, then Column 2 in the same row becomes filled with 3.if Column 1<0, then Column 2 in the same row becomes filled with 0. Thanks a lot!
vince_faller