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!
You can use a formula in Column 2 based on this expression:
If( :Column 1 > 0, 3, 0 )
You can copy it here, open the Formula Editor for Column 2, and paste it.
You can use a formula in Column 2 based on this expression:
If( :Column 1 > 0, 3, 0 )
You can copy it here, open the Formula Editor for Column 2, and paste it.
Thanks! It works.